swtich 1 green 0 red else blank no color

[Anonymous]

Hi , 

Can someone please make a formula for me. 

If the calue is 1 then its green, if its 0 then its red. And if none of those are selected nothing shows it blank

KPI value = var color=SELECTEDVALUE([on / off])

return

SWITCH(TRUE(),

    color="green",1,

    color="red",0,

    color= ''blank'',)

UNICHAR(11044)



I want his as a big circle, and not in a table for condotional formatting

[v-yulgu-msft · Accepted solution]

Hi @Anonymous ,

I didn't find the corresponding unicode for green circle, I inserted blue circle instead.

Please add below measure into a card visual.

KPI value =
IF (
    ISFILTERED ( Table1[On/Off] ),
    IF (
        SELECTEDVALUE ( Table1[On/Off] ) = 1,
        UNICHAR ( 128308 ),
        UNICHAR ( 128309 )
    ),
    BLANK ()
)

Best regards,

Yuliana Gu

[Anonymous]

My fault, I meant just white. That nothing shows at all, just plain white. Then when you click it changes. So the kpi card is just white, when you click on either 0 or 1 the colors will change. 

[v-yulgu-msft]

Hi @Anonymous ,

Still use above measure formula, then, turn off "Category Label", and set the color of "Data Label" to be the same as card's background.

Best regards,

Yuliana Gu