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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
amitchandak
Super User
Super User

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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

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

Adding spaces before the single digit totals worked. Thanks!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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