Circular Unichar code

[Anonymous]

I need to display the Circular Unichar code for Green and Red 

[cabc_xlorla]

Hey mate, try this number: 128308
Should work. : )

[Anonymous]

When I am using (11044) the size of the circle is very small and while I'm doing conditional formating the color changes for the circle.

If I use another UNICHAR value the color is not changing. Thanks in Advance

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Whne i use UNICHAR(127761) , i meet the same error as you did.

But it can work if i use 

KPILight = UNICHAR(11044)

Please refer to my pbix for more details.

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

It worked for me. But When I use UNICHAR(11044) instead of UNICHAR(122761), the size of the circle is geeting smaller. Is there anyway that I can get the same size as UNICHAR(122761). Please assist with it. Thank you.

[PattemManohar]

@Anonymous  Add a new column into your table as below

KPILight = UNICHAR(127761) 

Then do Conditional Formatting based on your criteria for Font Colours.

[Anonymous]

tried creating thea same using excel as source .. but when added the conditional formatting on the Font Color .. the coolor did not changed