Power BI Table Multiple Metrics

[boehnc]

Simplified visual and data set enclosed. I'm trying to get a table format with the enclosed data set. Multiple metrics with different data types in rows and within a category in columns. Not sure I'm thinking too hard, but best way to accomplish? Table/matrix doesn't seem to fit the need from what I'm seeing. Any thoughts would be appreciated.

 

[sandy666]

something like this?

 

[boehnc]

yes! How would this be displayed in a table or matrix format? Thanks.

 

[sandy666]

Power Queery M-Code

// Table1
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Patient", "Facility"}, "Attribute", "Value"),
    #"Added Prefix" = Table.TransformColumns(#"Unpivoted Other Columns", {{"Attribute", each "Avg. " & _, type text}}),
    #"Pivoted Column" = Table.Pivot(#"Added Prefix", List.Distinct(#"Added Prefix"[Facility]), "Facility", "Value"),
    #"Grouped Rows" = Table.Group(#"Pivoted Column", {"Attribute"}, {{"St. Agnes", each List.Average([Agnes]), type number}, {"Park", each List.Average([Park]), type number}, {"Friedmans", each List.Average([Friedmans]), type number}}),
    #"Rounded Off" = Table.TransformColumns(#"Grouped Rows",{{"St. Agnes", each Number.Round(_, 2), type number}, {"Park", each Number.Round(_, 2), type number}, {"Friedmans", each Number.Round(_, 2), type number}})
in
    #"Rounded Off"

then change Mortality values to % (format from the ribbon)