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 Guys,
I'm trying to use 'Matrix' to show some data but seems not working in my way.
the data I have is like below and I do not want to unpivit again as I need this format to calculate %
What I want is to display in this way for MTD, QTD and YTD
Actual | AOP | LE | LY | |
Gross Sales | ||||
Gross Profit | ||||
Contribution Margin | ||||
EBITA |
But Matrix cannot do it this way, it will be either for values
or for columns
any add-on suggestion that I can use to achieve this?
Thanks!
Solved! Go to Solution.
@Alanlu , For the display given in text format, calculation group can be used
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
@Alanlu , For the display given in text format, calculation group can be used
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Thanks amitchandak!
User | Count |
---|---|
88 | |
84 | |
66 | |
62 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
82 | |
71 |