Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
4 years ago
Solved

Conditional formatting icon change

Hi    Currently, this is how my conditional formatting Icon looks like, wondering if there is any way i can bring in the "Thumbs UP", "Thumbs Down" icon instead of a circle   is there any way i c...
Need Help
Show and Tell
  • themistoklis's avatar
    themistoklis
    4 years ago

    vjnvinod 

     

    from a quick check you forgot another closing bracket

    ALL('GDS Relationship Mapping')

    should be ALL('GDS Relationship Mapping'))

ALLUREAN's avatar
ALLUREAN
Solution Sage
4 years ago

I just change the post sorry, can you try with UNICODE instead of UNICHAR?

vjnvinod's avatar
vjnvinod
Impactful Individual
4 years ago

ALLUREAN 

 

still doesn't work

refer the error below

 

  • themistoklis's avatar
    themistoklis
    Community Champion
    4 years ago

    vjnvinod 

     

    Please use the following formula:

    Measure = IF (SUM(Sheet1[Values]) = 30, UNICHAR(128077), UNICHAR(128078))

     

    File also attached

    • vjnvinod's avatar
      vjnvinod
      Impactful Individual
      4 years ago

      themistoklis 

      it works for some reason, it's spreading to the Total column as well

      how do I stop not showing in the total?

       

       

      • themistoklis's avatar
        themistoklis
        Community Champion
        4 years ago

        vjnvinod 

         

        Actually there is no option where you can exclude the icon from totals.

        But there is a workaround in the measure.

         

        You just need to say that if the value is equal to total value then do not show the icon on totals.

         

        See attached file.

         

        Measure = IF (SUM(Sheet1[Values]) >= CALCULATE (SUM(Sheet1[Values]), ALL(Sheet1)),"", IF (SUM(Sheet1[Values]) = 30,  UNICHAR(128077), UNICHAR(128078)))