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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ailsazheng
Frequent Visitor

Nested sort breaks when I select filter for anything in my report

 

To my right is a visualization that is working properly. No filters have been selected. This is a list of projects broken into subcategories (the purple, blue, yellow, and gray colors) and each of these are sorted by the number of hours spent on each project.ailsazheng_0-1673656475074.png

 

Then a filter is selected...

Now I have filtered my visualization, and the sort immediately is no longer in descending order by project subcategory. I want the purple bars to be sorted from most to least, then the blue bars to be sorted from most to least, etc. like above.ailsazheng_1-1673656552275.png

 

I have attempted to use the Calculate() feature but it only seems to allow Booleans whereas I have multiple options in my filters. How can I do a nested sort? Thank you very much!

 

1 REPLY 1
lbendlin
Super User
Super User

I would try with a RankX measure , put that in the tooltips, and then sort by it.

 

Please provide sanitized sample data that fully covers your issue.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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