Forum Discussion
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...
from a quick check you forgot another closing bracket
ALL('GDS Relationship Mapping')
should be ALL('GDS Relationship Mapping'))
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)))
from a quick check you forgot another closing bracket
ALL('GDS Relationship Mapping')
should be ALL('GDS Relationship Mapping'))
thanks so much, this is really helpful