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'))

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)))

 

 

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

Another way to handle the total differently is to use ISINSCOPE.

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