Forum Discussion
Sort slicer value based on the numeric Value
Hello, I am looking to sort my Slicer value according to the numeric field ( Not ascending or descending). For example below country is sorted based on alphabets in a table but the requirement i...
It will depend on your table structure, but you could do this:
| Country | Population | Order |
| Australia | 4797400 | 2 |
| Canada | 7964900 | 1 |
| India | 4217600 | 3 |
| US | 3839600 | 4 |
Then use the Sort By Column on the modeling tab
This will sort the countrys by the sort order ascending
This will work if I have to sort in the table, but I want to values to be sorted in the Slicer, so it doesn't solve the purpose OR I am unable to understand your solution, could you elaborate.
It works for slicer ordering to. Below is the one im currently working on. You can see these are sorted descending, not ascending like default