Forum Discussion
Conditional formatting for a circle
- 3 years ago
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
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