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...
v-lili6-msft
Community Support
Community Supporthi, Anonymous
For the dim country table, you could Duplicate the fact table and then Group By it, and then add a conditional column for sort column in edit queries.
Either way, you need to define the rules in advance.
Regards,
Lin
Hello Lin,
I have created a column
1Rank = RANKX(FILTER('Time','Time'[Region M3]=EARLIER('Time'[Region M3])),'Time'[Actual],,DESC,Dense)
but when I am trying to sort my column Region M3 based on 1Rank, I am getting this error
Can you help? I am trying to sort the values in Slicer for Region M3 and Market M15 though they are not getting used in any visuals.