Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Circular Unichar code

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

Need Help
Show and Tell
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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.

6 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
    PattemManohar
    Community Champion
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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