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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.