How to Transpose the data in a matrix control

[Anonymous]

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

[Anonymous]

How wer you able to do this please? Under what format group do you find the Switch values to rows option?

[lbendlin]

In the values section.

You can always use the search box to hunt for settings.

[lbendlin · Accepted solution]

Note that the sort order is now borked - that is something you need to handle separately, via a sort column.