Pivot a Power BI Matrix

[peternznguyen]

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!

[jdbuchanan71 · Accepted solution]

On your matrix you can turn on 'Switch values to rows' and move the YYYY-MM to the columns.

[jdbuchanan71 · Accepted solution]

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

[jdbuchanan71]

I updated my first post with screen shots.

[peternznguyen]

I have tried to modiy the Matrix in different ways but did no help

[jdbuchanan71 · Accepted solution]

On your matrix you can turn on 'Switch values to rows' and move the YYYY-MM to the columns.

[peternznguyen]

How to sort by Month please? 

I don't see any from here?

[peternznguyen]

Ah, Excellent! Thank you so much!

[peternznguyen]

I have moved the YYYY-MM to the columns. Where is the 'Show values on rows' please?  Could you please give me some screenshots?