Sort Slicer Value By A Different Column

[SoDoLabs]

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...

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!

[jdbuchanan71 · Accepted solution]

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).

[SoDoLabs]

@jdbuchanan71 ,

It makes so much sense now. Thank you for your response!