Forum Discussion
sort slicer by another column
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?
OK. I found it myself. In the visual side, the visual must sort in the same way as well.
5 Replies
- DOLEARY85
Resident Rockstar
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
Helper II
From my screenshot in the original post, I already did those steps. I found the answer myself. Thank you anyway.
- smilikaFrequent Visitor
How did you solved this issue?
- garythomannCoGC
Impactful Individual
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.
- yishenhui
Helper II
OK. I found it myself. In the visual side, the visual must sort in the same way as well.