Sort Slicer Visual that uses IF Formulas

[chad_lenny]

I am trying to sort my Slicer so it shows as 0-.5, then .5-1, then 1-2 etc. See exampe Formula the Slicer is using and what is currently shows.

Tenure Group = IF(EMPLOYEE_EDV[Tenure]<.5,"0-.5",IF(EMPLOYEE_EDV[Tenure]<1,".5-1",IF(EMPLOYEE_EDV[Tenure] <2, "1-2", IF(EMPLOYEE_EDV[Tenure]<4,"2-4",IF(EMPLOYEE_EDV[Tenure]<6,"4-6",IF(EMPLOYEE_EDV[Tenure]<10,"6-10","More Than 10")))))). 

[Anand24]

Hi @chad_lenny ,
Instead of .5, type 0.5 and it will auto-sort itself to achieve the way yo want it right now.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[chad_lenny]

I tried that and it still sorts the 0.5-1 before the 0-0.5. 

[Anand24 · Accepted solution]

@chad_lenny ,
Make it 0.0-0.5 instead of 0-0.5. The values are formatted as TEXT and hence 0 comes later than 0.5 according to ASCII, hence this is happening.

Result:

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn