Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I'm trying to create a 2x2 matrix with 4 metrics that have been created.
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!
Solved! Go to 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
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
@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
User | Count |
---|---|
79 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |