Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
OneWithQuestion
Post Prodigy
Post Prodigy

Display values (measures) on rows instead of columns? AKA Pivot in Matrix

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:

beforebeforeafterafter

*but with years across the top, so I could see how they changed over time.  Just a screenshot I stole for an example.

 

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @OneWithQuestion

 

You most certainly can do this.


Below is a great blog post by Matt Allington where he explains exactly how to achieve this.

 

Measures on Rows – Here is How I did it





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
GilbertQ
Super User
Super User

Hi @OneWithQuestion

 

You most certainly can do this.


Below is a great blog post by Matt Allington where he explains exactly how to achieve this.

 

Measures on Rows – Here is How I did it





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

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! 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.