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

jeve's avatar
jeve
Frequent Visitor
7 years ago

Hi Lin,

 

Thanks for the reponse. I've done all the steps but when I click on "Sort by Column" there's no drop down option? Any idea what could be the cause of that?

v-lili6-msft's avatar
v-lili6-msft
Community Support
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