Create a 2 x 2 matrix populated with 4 metrics and column / row labels?

[Anonymous]

Hi, 

I'm trying to create a 2x2 matrix with 4 metrics that have been created.  

• The reason is due to space limitations of KPIs for a scorecard.

Essentially I would Like it to look like the below photoshopped image

Out of the Box, If I put these 4 metrics as values in a matrix it's displayed like this. 

If I select 'show on rows' under the values tab, it will put them all in one row as columns. 

I've tried a few other options with multi-row cards, and having 2 tables, but this is the only option I really have to minimize the space of the information to get it in the real estate I have to work with. 

Thank you for any help on this one!

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

You need to add a table 'Table2' :

Then try formulas as below:

Vs LY = 
SWITCH (
    SELECTEDVALUE ( Table2[Type] ),
    "Var$", [Var$ vs LY],
    "Var%", FORMAT ( [Var% vs LY], "Percent" )
)

Vs Budget = 
SWITCH (
    SELECTEDVALUE ( Table2[Type] ),
    "Var$", [Var$ vs Budget],
    "Var%", FORMAT ( [Var% vs Budget], "percent" )
)

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Anonymous , refer to this video on calculation group, I have discussed a few formats like this 

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0