Forum Discussion
Custom Dropdown Order
Hello,
I have a list of countries in a dropdown that I need in a custom order. I have created a new column numbering them 1-16 in the correct order. However, all current answers on the next step refer an option in the 'Modelling' ribbon that is no longer there since the latest updates.
How can I sort my dropdown by the 1-16 column I created?
Many thanks,
Mike
Hi PBIMike ,
You could sort the number column at first ( ascending/descending ), then refer to the solution of parry2k.
4 Replies
- parry2kSuper User
PBIMike when you select a County column, you will see a new menu option called Column Tools and there is an option to Column sort
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
- PBIMikeHelper III
Thanks both, I had managed to stumble on that one and link them together already. However, the drop down list still shows all options alphabetically.
How can I tell the drop down in which order to display?
Many thanks,
Mike