Reply
Member
Posts: 212
Registered: ‎08-05-2015
Accepted Solution

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.

 


Accepted Solutions
Super Contributor
Posts: 1,464
Registered: ‎06-24-2015

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

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

View solution in original post


All Replies
Super Contributor
Posts: 1,464
Registered: ‎06-24-2015

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

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

Established Member
Posts: 221
Registered: ‎07-28-2015

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

Now there's a built in option for this in the new Matrix visual.

Go to matrix properties -- Values -- Show on rows = on