Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a matrix control in Power BI showing like the table below with the name in the rows on the left. The Total column is a "calculated column" not a subtotal created by the control.
Name | Sales | Purchases | Total |
Multi Manager | 500 | 200 | 700 |
High Income Growth | 300 | 400 | 700 |
Growth & Income | 100 | 300 | 400 |
Next Generation | 300 | 300 | 600 |
I would like to flip the table by transposing the matrix so that the name in the rows above are now shown in the columnss at the top and the numbers go across instead of downwards like in the table below.
Name | Multi Manager | High Income Growth | Growth & Income | Next Generation |
Sales | 500 | 300 | 100 | 300 |
Purchases | 200 | 400 | 300 | 300 |
Total | 700 | 700 | 400 | 600 |
Solved! Go to Solution.
Note that the sort order is now borked - that is something you need to handle separately, via a sort column.
How wer you able to do this please? Under what format group do you find the Switch values to rows option?
In the values section.
You can always use the search box to hunt for settings.
Note that the sort order is now borked - that is something you need to handle separately, via a sort column.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |