Forum Discussion
Solved
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(EM...
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
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 !!! |
I 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