cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
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.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 264 members 2,963 guests
Please welcome our newest community members: