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 be increased overtime).
I have tried to create a new table by a DAX function but did not help
Could you please help me?
Many thanks!
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
7 Replies
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=EnterpriseDNAI updated my first post with screen shots.