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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
olivere91
Helper I
Helper I

Sort by ASC when value is present

Hello,

I'm trying to sort a column, by another column when it's present. The picture shows Categories, in bold, Names as unbolded text, and beneath the names not visible in the picture is a GL number for each name. This GL number is only present in names under the category SG&A.  I'm trying to sort these values by ascending them in my matrix. Any ideas? 

 

 

 

Screenshot 2023-03-26 153216.png

1 REPLY 1
amitchandak
Super User
Super User

@olivere91 , if you sort category column ascending then only below level will sort ascending . As of now, multiple sort is not available in Matrix visual

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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