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'))
it works for some reason, it's spreading to the Total column as well
how do I stop not showing in the total?
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
Another way to handle the total differently is to use ISINSCOPE.
IF ( ISINSCOPE ( Sheet1[Dimension] ), IF ( SUM ( Sheet1[Values] ) = 30, UNICHAR ( 128077 ), UNICHAR ( 128078 ) ) )
