Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register 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:
before
after
*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!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
50 | |
31 | |
26 | |
26 | |
25 |
User | Count |
---|---|
61 | |
49 | |
29 | |
24 | |
23 |