Conditional formatting icon change

[vjnvinod]

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 can achieve this?

[ALLUREAN]

Try it like:

ICON = IF(MIN('GDS relationShip Mapping'[Index]) < 1, UNICHAR(128078), UNICHAR(128077))

and use this measure in a visual

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

[ALLUREAN]

You can create a measure that then use in visual like 

ICON = IF(MIN('GDS relationShip Mapping'[Index]) < 1, UNICHAR(128078), UNICHAR(128077))

or if you have already measure showing 0,1,2 flags just modify it

[vjnvinod]

@ALLUREAN 

Codes are not reading, not sure why

[ALLUREAN]

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

[vjnvinod]

@ALLUREAN 

still doesn't work

refer the error below

[themistoklis]

@vjnvinod 

Please use the following formula:

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

File also attached

[vjnvinod]

@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]

@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]

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

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

[vjnvinod]

@themistoklis 

tried replicating the formula but getting some error

[themistoklis · Accepted solution]

@vjnvinod 

from a quick check you forgot another closing bracket

ALL('GDS Relationship Mapping')

should be ALL('GDS Relationship Mapping'))

[vjnvinod]

thanks so much, this is really helpful