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.
Hello,
I have an matrix visual that would display an "usual pivot" information: Description on rows, Year-Month on columns and two measures budget (BGT) and actual (ACT) in values:
Is it possible to have the information grouped as in the picture below?:
Kind Regards,
Lucian
Solved! Go to Solution.
I think you'll need a new dimension to add to the columns.
Create a new table dimType with a single Type column containing two values "BGT" and "ACT" and then a new measure that switches based on this new dimension.
SwitchMeasure =
SWITCH (
SELECTEDVALUE ( dimType[Type] ),
"BGT", [BGT],
"ACT", [ACT]
)
You can use dimType[Type] in your matrix columns and this measure for the values.
I think you'll need a new dimension to add to the columns.
Create a new table dimType with a single Type column containing two values "BGT" and "ACT" and then a new measure that switches based on this new dimension.
SwitchMeasure =
SWITCH (
SELECTEDVALUE ( dimType[Type] ),
"BGT", [BGT],
"ACT", [ACT]
)
You can use dimType[Type] in your matrix columns and this measure for the values.
Hi @AlexisOlson ,
Thank you so much for your response. Indeed, it did the "trick". 👍
Kind Regards,
Lucian
User | Count |
---|---|
95 | |
89 | |
70 | |
63 | |
58 |
User | Count |
---|---|
149 | |
113 | |
95 | |
80 | |
72 |