Forum Discussion
Helper IIISort Slicer Values by Number and Category
Hi sheap069 ,
According to your description, here's my solution.
1.Create a calculated column.
Rank = RANKX('Table','Table'[Status],,DESC,Dense)Get this.
2.Put the ID column in a slicer, first click the slicer visual, then click the ID column in the Fields pane.
Then under the Column tools ribbon, select Sort by column>Rank.
Get the expected result.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super Usersheap069 you need to add a new column that concatenates Status and ID and then use this new column in the slicer, and in the slicer, use the sort option.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
Helper IIIHello,
Sorry I don't quite understand what you mean, can you be more specific? If I do this I still have the order as
1
2
3
4
5
6
7
8
9
10
Instead of the desired output above. I need the inactives listed first in numerical order, then the actives in numerical order.