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
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!
Solved! Go to Solution.
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
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
I updated my first post with screen shots.
I have tried to modiy the Matrix in different ways but did no help
On your matrix you can turn on 'Switch values to rows' and move the YYYY-MM to the columns.
How to sort by Month please?
I don't see any from here?
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?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
107 | |
102 | |
92 | |
69 |
User | Count |
---|---|
173 | |
135 | |
131 | |
96 | |
95 |