Forum Discussion

qwertzuiop's avatar
qwertzuiop
Advocate III
6 years ago
Solved

How can I sort a dropdown-list?

Dear PowerBI-Community

 

I thought it was easy, but I don't know how.
I would like to sort this drop-down list accordingly.

Mon
Tue
Wed
...

How can I do this without affecting the rest of my modeling?

 

 

Thank you so much for your help!

Cheers

qwertzuiop

Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi qwertzuiop ,

     

    We can create a seprate calculated table to meet your requirement:

     

    SortTable = 
ADDCOLUMNS (
    DISTINCT ( 'Table'[Wochentag-kurz] ),
    "Index", SWITCH (
        'Table'[Wochentag-kurz],
        "Mo", 1,
        "Di", 2,
        "Mi", 3,
        "Do", 4,
        "Fr", 5,
        "Sa", 6,
        "So", 7,
        0
    )
)

     

    Then set the name column sort by index column and create a relationship between the origin table.

     

     

    Then we can use the name column in new sort table as the slicer field without changing the origin table.

     


    BTW, pbix as attached.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi qwertzuiop ,

     

    We can create a seprate calculated table to meet your requirement:

     

    SortTable = 
ADDCOLUMNS (
    DISTINCT ( 'Table'[Wochentag-kurz] ),
    "Index", SWITCH (
        'Table'[Wochentag-kurz],
        "Mo", 1,
        "Di", 2,
        "Mi", 3,
        "Do", 4,
        "Fr", 5,
        "Sa", 6,
        "So", 7,
        0
    )
)

     

    Then set the name column sort by index column and create a relationship between the origin table.

     

     

    Then we can use the name column in new sort table as the slicer field without changing the origin table.

     


    BTW, pbix as attached.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.