Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.