Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to take a dataset similar to the following
Division | Market | Sales | Profit |
A | Country x | 123 | 23 |
B | Country b | 234 | 34 |
C | Country c | 345 | 45 |
And want to visualize it using a matrix to look something like this
Division | Sales | Profit | ||||||
Market | A | B | C | Total | A | B | C | Total |
Country b | 234 | 234 | 34 | 34 | ||||
Country c | 345 | 345 | 45 | 45 | ||||
Country x | 123 | 123 | 23 | 23 | ||||
Total | 123 | 234 | 345 | 702 | 23 | 34 | 45 | 102 |
I can do it easily enough in Excel using Pivot Table by moving the Values before the Header, but I have not found a way to achieve the same in PBI and end up with something like the following
Division | A | B | C | Total | ||||
Market | Sales | Profit | Sales | Profit | Sales | Profit | Sales | Profit |
Country b | 234 | 34 | 234 | 34 | ||||
Country c | 345 | 45 | 345 | 45 | ||||
Country x | 123 | 23 | 123 | 23 | ||||
Total | 123 | 23 | 234 | 34 | 345 | 45 | 702 | 102 |
Any help would be appreciated. Thanks
Solved! Go to Solution.
@verminbaron , Measure on top is not possible in power bi Matrix yet. You can unpivot the table and convert the sales and profit as rows and then you can have that table
https://radacad.com/pivot-and-unpivot-with-power-bi
or refer
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795
@verminbaron , Measure on top is not possible in power bi Matrix yet. You can unpivot the table and convert the sales and profit as rows and then you can have that table
https://radacad.com/pivot-and-unpivot-with-power-bi
or refer
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |