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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
AdrienneB
Frequent Visitor

Is there a way to truly sort all levels of a slicer in descending order?

This is one of those things that bugs me a lot so asking for your help. All I want to do is have a nested/hierarchical slicer that sorts each level in descending order (not just the bottom level).

 

Ascending works as that is the default but I need all levels in descending (we will load a lot more data soon). This is not a date sorting issue, all nested slicers work this way. Basically the question is if there is a way to truly sort all levels of the slicer in descending order. It seems to me that only one field can be selected for descending order, the others will remain ascending.

 

I tried creating a hierarchy in the model and use that but still get the same results.

Lowest level sorted in descending order but the higher ones are notLowest level sorted in descending order but the higher ones are notDescending order applied at higher level does not sort lower levels in descending orderDescending order applied at higher level does not sort lower levels in descending order

1 REPLY 1
lbendlin
Super User
Super User

Not sure why you would want to do that but by creating a dedicated sort column for each level in your hierarchy you can achieve that.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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