Conditional formatting for a circle

[Anonymous]

I made below circle by unichar(9898) and unichar(9899) in card visual, however, i would like to make it be a specific color, like blue. I have tried to use the conditional formatting but it seems that it does not work. Each row in my data view have unichar(9898) and unichar(9899) already

 

 

[AnthonyJoseph · Accepted solution]

Hi @Anonymous 

I think I get what you are asking... I used UNICHAR(11044) to create circle and change font color.

1) Create a column 'Circle'.

Circle = UNICHAR(11044)

2) Create another column (font color) to determine the color of the circle based on the condition, for example: here I m trying to determine color based on the ID value.

font color = SWITCH(
    TRUE(),
    'Table'[ID] = 0, "#D9291C",
    'Table'[ID]= 1, "#ED8B00",
   'Table'[ID] = 2, "#FFCD00",
   'Table'[ID] = 3, "#A0DCFF",
   'Table'[ID] = 4, "#6FC2B4",
    'Table'[ID] = 5, "#C4D600",
    "#046A38"
)

3) Then use the "font color" column in card/any visual i.e.using  font color option and select the function in the Color category. Then choose "Field value" in format style and "first font color" in the below option. Pasted below the screenshot for reference.

4) Click OK 🙂 and you will be able to see the below color card visual

This should work for you as well...

Thanks,

AnthonyJoseph

[AnthonyJoseph]

Hi @Anonymous 

If in case you would want to view as table,  then you can use conditional formatting option in the circle column so that the output looks like:

Also you can use any HEX color value (that I have included in the calculated column-"font color" ).

Hope this helps!

Thanks,

AnthonyJoseph

[Telmoogc]

Hi @AnthonyJoseph , i have a similar problem, but I need to decide what color to apply on the circle based on 3 options:

if the value is over 0
if the value is less then 0
if the value is equal to 0

Do you have any tip for me (My visual is a table)??