Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Circular Unichar code

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

1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

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)

21.png

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.

View solution in original post

6 REPLIES 6
cabc_xlorla
Advocate IV
Advocate IV

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

Anonymous
Not applicable

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
Community Support
Community Support

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)

21.png

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
Not applicable

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
Community Champion
Community Champion

@Anonymous  Add a new column into your table as below

 

KPILight = UNICHAR(127761) 

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

 

image.png

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a PBI Community Champion




Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.