Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi!
The typical layout of data in a Matrix exhibit in Power BI is like this:
2015 | 2016 | 2017 | 2018 | Total | ||||||
Attribute | Measure1 | Measure2 | Measure1 | Measure2 | Measure1 | Measure2 | Measure1 | Measure2 | Measure1 | Measure2 |
A | 89 | 70 | 44 | 100 | 32 | 76 | 16 | 98 | 181 | 344 |
B | 37 | 57 | 77 | 98 | 46 | 84 | 46 | 28 | 206 | 267 |
C | 23 | 19 | 91 | 40 | 72 | 18 | 62 | 84 | 248 | 161 |
Total | 149 | 146 | 212 | 238 | 150 | 178 | 124 | 210 | 635 | 772 |
I would like it to be more like a possible format that is attainable with an Excel pivot table, like this:
2015 | 2016 | 2017 | 2018 | Total | 2015 | 2016 | 2017 | 2018 | Total | |
Attribute | Measure1 | Measure1 | Measure1 | Measure1 | Measure1 | Measure2 | Measure2 | Measure2 | Measure2 | Measure2 |
A | 89 | 44 | 32 | 16 | 181 | 70 | 100 | 76 | 98 | 344 |
B | 37 | 77 | 46 | 46 | 206 | 57 | 98 | 84 | 28 | 267 |
C | 23 | 91 | 72 | 62 | 248 | 19 | 40 | 18 | 84 | 161 |
Total | 149 | 212 | 150 | 124 | 635 | 146 | 238 | 178 | 210 | 772 |
This allows you to scan along the rows for each measure to see if there is any trend with time, whereas the mixing of measure across a row in the typical matrix layout makes this more difficult.
Does anyone know if this is possible with a Power BI Matrix or other visualisation?
Many thanks for any help.
Mark
HI @Anonymous,
Nope, this is impossible. If column label is based on two columns, you can modify sort order in column field to change grouping order. (measures can't achieve this)
Regards,
Xiaoxin Sheng