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?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi jeve . For me, the "Sort by Column" drop-down only becomes enabled when I select both the slicer and the associated table in the Fields pane. Also, the "Sort by Column" drop-down does not show all fields within the table. It shows columns but no measures. I hope this is helpful.