Reply
Member
Posts: 158
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
Highlighted
Super Contributor
Posts: 1,180
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
Highlighted
Super Contributor
Posts: 1,180
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