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
Is there no way to use a matrix in PowerBI like you can in Excel where you can have your measures be on the rows instead of columns?
So if I had two measures and instead of showing them in the columns, I wanted my years across the top for columns and instead wanted the two measures on the rows, to repeat for each item on the rows:
*but with years across the top, so I could see how they changed over time. Just a screenshot I stole for an example.
Solved! Go to Solution.
You most certainly can do this.
Below is a great blog post by Matt Allington where he explains exactly how to achieve this.
You most certainly can do this.
Below is a great blog post by Matt Allington where he explains exactly how to achieve this.
Now there's a built in option for this in the new Matrix visual.
Go to matrix properties -- Values -- Show on rows = on
this should be on top!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.