Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!