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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

How do I change the row/col orientation of a matrix?

I want to show data in a matrix but I want the identifiers to be the columns and the values as the rows if that makes sense.

 

rasberryPie_0-1698990241443.png

This matrix above is kind of how I want it. But what I really want is with the Dem/FIN to be like side-by-side. What I want to show is like the table i created below.

DemFIN
valuevalue
valuevalue
valuevalue

 

 

rasberryPie_1-1698990261773.png

If I put Dem/FIN into the Columns field, this is what I get and its not what I want.

 

EDIT 1

The values shown are measures

 

Any suggetsions?

 

1 ACCEPTED SOLUTION
Kishore_KVN
Super User
Super User

Hello @Anonymous ,

As seen in you pic, drill down is the best way to represent the data and read it but you want values in rows which is not possible because its a measure and you can not add it directly to a row in matrix. If you want those values only as rows then created a calculated table with all these calculations and use those columns values in the rows. 

 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

View solution in original post

2 REPLIES 2
Bmejia
Super User
Super User

Can you swith the values in the column section. Have the "Test" on top and right below the Dem/Fin.  
 you will get something like this 

Test
DemFin




 

Kishore_KVN
Super User
Super User

Hello @Anonymous ,

As seen in you pic, drill down is the best way to represent the data and read it but you want values in rows which is not possible because its a measure and you can not add it directly to a row in matrix. If you want those values only as rows then created a calculated table with all these calculations and use those columns values in the rows. 

 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors