Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

 

MCornish's avatar
MCornish
Responsive Resident
6 years ago

You would need to have a 1to1 mapping from Region M3 to Rank1

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Is there any way to achieve it? as per my knowledge data is vast and there are multiple region_M3 and market_M15 and aggregation is an issue.