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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors