Forum Discussion
Solved
Pivoting Data in a Matrix
I want to be able to pivot how data looks in a matrix. I have the following table currently existing: Item A B A B Hour 9 9 10 10 Day Mon xyz xyz xyz xyz T...
Hi andrewb95 ,
I created some data:
Here are the steps you can follow：
1. Enter the power query, select ValueA and ValueB two columns, click Transform-Unpivot Columns
Result:
2. Create calculated column.
Day_of_the_week = 'Table'[Day of the week] &""& 'Table'[Value]3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Not sure if it 100% meets you requirement but in the Values section of the matrix Format pane there is a setting called "Show On Rows". Try enabling it.