Forum Discussion
How to Transpose the data in a matrix control
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 |
Note that the sort order is now borked - that is something you need to handle separately, via a sort column.
