Forum Discussion

jeve's avatar
jeve
Frequent Visitor
7 years ago
Solved

Sort Slicer Values

I have a list of data with 3 possible values - B-CS, C-CS and LT. When applying the slicer it defaults to sorting alphabetically; is it possible to sort by - LT, B-CS and then C-CS?
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, jeve 

    If the rank is a column not a measure? Measure won't show in it.

    If you still have the problem, please share a simple pbix file for us have a test.

     

    By the way, the column should be created in edit queries, not a calculate column.

    and here is my sample pbix file, please try it.

     

    Best Regards,

    Lin

Anonymous's avatar
Anonymous
Not applicable
7 years ago

hi jeve 

What you can do is add a number infront of the sort order that you prefer. Then you can sort it. Its  workaround.

Else you can create an index for the sort in edit query. While visualising try to select the column ( i.e. the column which you want to sort and then goto modeling tab and specify the Sort Order --> Index column.

Thats all i can think of :)

Thanks