cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
branden_dahlem
Frequent Visitor

Looking to re-order Dropdown group list

Need help correctly sorting a list of groups in a dropdown that begin with '0-2' and end with '16+'. I have already tried changing the data type, both in the SQL query the datas being pulled from, and the Query Editor built-in to Power BI. 

Power_bi_dropdown.png

 

I was wondering if anyone has experienced this issue before, and if so, what they did to remedy it? 

 

Thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

Re: Looking to re-order Dropdown group list

There two ways. Create a column where you give a sorting order. And mark that as sorting the column in the Model view. 

 

Refer to the second half of blog

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

 

Second when this not a join column. Insert space(one or more) before the text to make it sort in the order you want. Space is below character in sorting.

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin


View solution in original post

2 REPLIES 2
Super User IV
Super User IV

Re: Looking to re-order Dropdown group list

There two ways. Create a column where you give a sorting order. And mark that as sorting the column in the Model view. 

 

Refer to the second half of blog

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

 

Second when this not a join column. Insert space(one or more) before the text to make it sort in the order you want. Space is below character in sorting.

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin


View solution in original post

branden_dahlem
Frequent Visitor

Re: Looking to re-order Dropdown group list

Adding spaces before the single digit totals worked. Thanks!

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors