Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello community.
Im working in a matrix using 3 measures (Measure1, measure2 and measure3) and I'm using the month field from the calendar in columns therefore the matrix will group the 3 measures by month (Month1 - Measure1, Measure2, Measure3||Month2- Measure1, Measure2, Measure3...etc). Is there any way I can group this by measure and show Measure1-Month1, Month2, Month3|| Measure2-Month1, Month2, Month3... etc.
Thank you in advance for the support.
Solved! Go to Solution.
Hi @gadielsolis
I would recommend creating a calculation group to be used for measure selection, along the lines of this article.
https://exceleratorbi.com.au/dynamic-formatting-of-switch-measures/
Then you can create a visual grouped by the calculation item column first, followed by month, with an arbitrary measure (which will be overridden by the calculation items).
Are you able to get that working?
Hi @gadielsolis
I would recommend creating a calculation group to be used for measure selection, along the lines of this article.
https://exceleratorbi.com.au/dynamic-formatting-of-switch-measures/
Then you can create a visual grouped by the calculation item column first, followed by month, with an arbitrary measure (which will be overridden by the calculation items).
Are you able to get that working?
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
13 |
User | Count |
---|---|
91 | |
85 | |
46 | |
28 | |
21 |