Forum Discussion

SoDoLabs's avatar
SoDoLabs
Regular Visitor
7 years ago
Solved

Sort Slicer Value By A Different Column

Hi,

I'm trying to sort the values in a slicer based on a different column within the same table. I was able to find the following post; however, the solution didn't work at my end.

https://community.powerbi.com/t5/Desktop/How-can-I-sort-the-text-values-in-a-filter-object/m-p/24603#M7973

I followed the post and made sure I set Sort by Column with the column that I want to use for sorting, but I’m not seeing the expected sorting results.

 

I would like to see slicer values in the following order:

  • CCC
  • DDD
  • AAA
  • BBB

 

Thank you for any help you can offer!

  • Hello SoDoLabs 

    What you need to do is select the column you are trying to sort (name in this case) then in the sort by drop down pick the column you want to use (order).

     

5 Replies

  • Hello SoDoLabs 

    What you need to do is select the column you are trying to sort (name in this case) then in the sort by drop down pick the column you want to use (order).

     

    • GabrielC78's avatar
      GabrielC78
      Frequent Visitor

      Hello,
      Do you know why when I select a value in another slicer concerning the same table it sorts back alphabetically the slicer (normally sort by a column i choose) ?

      Thanks in advance
      Gabriel

      • jdbuchanan71's avatar
        jdbuchanan71
        Super User

        GabrielC78 

        I don't, mine does not behave that way.  You can see the months stay sorted in the correct order even when I apply a filter to the Day slicer.  Both of these fields are from my Dates table.