cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mmace1 Member
Member

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

Accepted Solutions
blopez11 Established Member
Established Member

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

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,

2 REPLIES 2
blopez11 Established Member
Established Member

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

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 Member
Member

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

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

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 43 members 1,017 guests
Please welcome our newest community members: