sort slicer by another column

[yishenhui]

Hi,

I want sort the value in a slicer by another column in the same table. I did in the table level, click the value field then sort on another column desc. However, when I create slicer, it still use value as the sort field. Did I anthing wrong or missed any steps?

[garythomannCoGC]

In Power BI, how do I sort slicer values (other than by name)? 

Use the Eric Barr answer.

The trick is to highlight the column header (Table View).  Then use Columns tools (ribbon) > Sort by column to then choose the 'hidden' sorting column.

[smilika]

How did you solved this issue?

[yishenhui · Accepted solution]

OK. I found it myself. In the visual side, the visual must sort in the same way as well.

[DOLEARY85]

Hi, 

select the field in the data pane on report view. Then on the column tools ribbon select sort by column and select your sort order.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[yishenhui]

From my screenshot in the original post, I already did those steps. I found the answer myself. Thank you anyway.