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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jhdavis
Regular Visitor

Matrix Column sorting

Hey guys, so I know in a matrix that you can sort value columns when nothing in in "columns" like below:

 

 

help1.PNG

 

What if there is something in "columns" such as Country. I still want to sort the table rows by the "Client $ Spend" column. Or even sort the country columns by the highest client $ spend total.

 

help2.PNG

 

Thoughts?

 

Thanks

3 REPLIES 3
v-chuncz-msft
Community Support
Community Support

@jhdavis,

 

Alternatively, select Unpivot Columns, Merge Columns and Pivot Column in Query Editor in turn. You may also vote this idea up.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I agree those fix the current visual. But I am trying to make this a dynamic dashboard that pulls off an SSAS cube, so it just knows to sort by that column always, no matter the data loaded. I did vote up that idea because that's exactly what I mean, being able to sort by rows (after the update comes out for listing values in rows instead of columns). 

parry2k
Super User
Super User

only thing i can think of bring country to row level and use inline drill down to next level and sort by Cost $ Spend. Turn off step layout.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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