Matrix I want a column as a row with value

[Syndicate_Admin]

Good morning community.

I intend to do this in Power BI. But I don't know how to approach it without creating an intermediate table with transposed columns and rows.

I have this matrix:

And I want to get to this, where the main row is what surrounds you in red, the next row is what I circle in blue and the column header is what I surround in black.

Thank you!

[v-jingzhang · Accepted solution]

Hi @Syndicate_Admin 

You could use a Matrix visual. Put the red column in Rows, black column in Columns and three blue columns in Values.

Then in the Format pane, turn on Show on rows, turn off Stepped layout and turn off Row/Column subtotals.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.