Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
peternznguyen
Helper II
Helper II

Pivot a Power BI Matrix

Hi Experts,

 

I currently have data displayed in a Power BI Matrix as shown below.

 

peternznguyen_1-1714622731885.png

 

 

peternznguyen_2-1714622742880.png

 

 

Now my boss wants to pivot the Matrix to display the data as shown below (YYYY-MM will be increased overtime).

 

peternznguyen_0-1714622703225.png

 

I have tried to create a new table by a DAX function but did not help

Could you please help me?

Many thanks!

2 ACCEPTED SOLUTIONS
jdbuchanan71
Super User
Super User

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

jdbuchanan71_0-1714623977961.png

jdbuchanan71_1-1714624004540.png

jdbuchanan71_2-1714624012307.png

 

 

View solution in original post

jdbuchanan71
Super User
Super User

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

 

View solution in original post

7 REPLIES 7
jdbuchanan71
Super User
Super User

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
Super User
Super User

I updated my first post with screen shots.

peternznguyen
Helper II
Helper II

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

peternznguyen_0-1714623791678.pngpeternznguyen_1-1714623803081.png

 

peternznguyen_2-1714623813684.pngpeternznguyen_3-1714623820365.png

 

 

 

jdbuchanan71
Super User
Super User

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

jdbuchanan71_0-1714623977961.png

jdbuchanan71_1-1714624004540.png

jdbuchanan71_2-1714624012307.png

 

 

How to sort by Month please? 

peternznguyen_0-1714624573622.png

I don't see any from here?

 

peternznguyen_1-1714624619052.png

peternznguyen_2-1714624656644.png

 

Ah, Excellent! Thank you so much!

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.