Forum Discussion
Pivot a Power BI Matrix
Hi Experts, I currently have data displayed in a Power BI Matrix as shown below. Now my boss wants to pivot the Matrix to display the data as shown below (YYYY-MM will...
On your matrix you can turn on 'Switch values to rows' and move the YYYY-MM to the columns.
Take a look at this video about how to set the sorting on month names.
https://www.youtube.com/watch?v=DY5IWLcgBGA&ab_channel=EnterpriseDNA
On your matrix you can turn on 'Switch values to rows' and move the YYYY-MM to the columns.
I have moved the YYYY-MM to the columns. Where is the 'Show values on rows' please? Could you please give me some screenshots?
Ah, Excellent! Thank you so much!
How to sort by Month please?
I don't see any from here?