Forum Discussion

PBIMike's avatar
PBIMike
Helper III
6 years ago
Solved

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

  • 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!

    • parry2k's avatar
      parry2k
      Super User

      PBIMike here 

       

       

      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!

      • PBIMike's avatar
        PBIMike
        Helper 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