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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
mmace1
Impactful Individual
Impactful Individual

Is there a way to order the options in a dropdown filter?

By default, the options in a dropdown filter are arranged A-Z alphabetically.

 

What if I wanted to say, reverse that order?  Or even do a custom order?   Are either currently possible?

 

Thanks,

 

Capture.JPG

1 ACCEPTED SOLUTION
blopez11
Resident Rockstar
Resident Rockstar

For reverse sort, you should be able to select the "..." (More options) on your filter visual and see a sort option

 

If you want a custom sort, then you need to create a sort key associated with each value, then go to the Data view, select your table, then select Cust # .  Then in the Modeling tab, select Sort by Column and select the sort key

 

Hope this helps,

View solution in original post

2 REPLIES 2
blopez11
Resident Rockstar
Resident Rockstar

For reverse sort, you should be able to select the "..." (More options) on your filter visual and see a sort option

 

If you want a custom sort, then you need to create a sort key associated with each value, then go to the Data view, select your table, then select Cust # .  Then in the Modeling tab, select Sort by Column and select the sort key

 

Hope this helps,

mmace1
Impactful Individual
Impactful Individual

Wow, that was there the entire time...OK, thank you!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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