cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ThomasDay
Impactful Individual
Impactful Individual

Transpose Rows and Columns in Matrix

Hello Fellow Powerbi'ers,

 

I would very much like to transpose a matrix.  I doubt that's everybody's dream but it somehow doesn't seem crazy hard as an idea.  I looked in the ideas board and couldn't find references to the idea.  Anyone know if it's on there and I didn't see it or if it's already been declined?

 

Anyone else think it's useful?  Or better--anyone have a workaround?

Tom

1 ACCEPTED SOLUTION
ThomasDay
Impactful Individual
Impactful Individual

@jahida  Great answer jahida...As I was thinking through how to answer your question I untangled the problem.  First, it's a visual I was struggling with.  And several columns I was using were percentile metrics computed from a selection of "provider" records.  This selection is not the same as the selection of providers I was looking to use as columns--so I was struggling to parse the values from that slicer to use as columns.  Anyway, without getting too tangled up in describing the jumble I was in, your question had me just put the providers as columns...and that works great.

View solution in original post

9 REPLIES 9
treel
Advocate I
Advocate I

I was able to transpose data in a Matrix visualization by using the formatting options in the specific visualizations.  Select Values>Show on Rows (slider)>ON.

 

Hope this helps...

Todd

This needs to be considered a solution.

This absolutely resovled the issue for me.

Well done @treel 

Anonymous
Not applicable

very useful solution!!!

This is amazing!!! Thank you. It should be marked as solution.

Very helpful! Thank you!

jahida
Impactful Individual
Impactful Individual

In what context would you like to do the transpose? If we're discussing a Table, there's an M function for it (Table.Transpose).

 

If you want to do it in a matrix visual, I've got nothing, but I'd be interested to see what matrix visual you built with enough dimensions to make that a useful feature.

ThomasDay
Impactful Individual
Impactful Individual

@jahida  Great answer jahida...As I was thinking through how to answer your question I untangled the problem.  First, it's a visual I was struggling with.  And several columns I was using were percentile metrics computed from a selection of "provider" records.  This selection is not the same as the selection of providers I was looking to use as columns--so I was struggling to parse the values from that slicer to use as columns.  Anyway, without getting too tangled up in describing the jumble I was in, your question had me just put the providers as columns...and that works great.

View solution in original post

@ThomasDay;I;m new to PowerBI, I request you to please elaborate on the solution for transposing rows and columns in Matrix display. 

ThomasDay
Impactful Individual
Impactful Individual

@prady2581 You can't transpose a matrix in a visual.  You'll need to find another way.  Tom

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors