March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
Solved! Go to Solution.
@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.
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
Perfect!
Very useful solution
very useful solution!!!
This is amazing!!! Thank you. It should be marked as solution.
Very helpful! Thank you!
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.
@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.
@ThomasDay;I;m new to PowerBI, I request you to please elaborate on the solution for transposing rows and columns in Matrix display.
@prady2581 You can't transpose a matrix in a visual. You'll need to find another way. Tom
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
87 | |
85 | |
70 | |
51 |
User | Count |
---|---|
205 | |
153 | |
97 | |
79 | |
69 |