Forum Discussion
Sort Slicer Visual that uses IF Formulas
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")))))).
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
3 Replies
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 !!!
LinkedInI tried that and it still sorts the 0.5-1 before the 0-0.5.
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
