Forum Discussion

sheap069's avatar
sheap069
Icon for Helper III rankHelper III
4 years ago
Solved

Sort Slicer Values by Number and Category

Hello, I have data as follows ID Status 1 Inactive 2 Inactive 3 Active 4 Inactive 5 Active 6 Inactive 7 Inactive 8 Inactive 9 Active 10 Active I want...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    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 _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

sheap069 add new column

 

Column from Slicer  =

Table[Status] & "-" & Table[Id]

 

and use this column in the slicer, and sort slicer desc

 

 

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

sheap069's avatar
sheap069
Icon for Helper III rankHelper III
4 years ago

Hello parry2k ,

I tried this and I have data that goes beyond 100. I'm getting this output:

Inactive - 1

Inactive - 10

Inactive - 11

...

How can this be fixed?

Thanks