Looking to re-order Dropdown group list

[branden_dahlem]

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. 

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

Thanks

[amitchandak · Accepted solution]

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

[branden_dahlem]

Adding spaces before the single digit totals worked. Thanks!