Q: Formatting Unicode Circles with DAX

[Anonymous]

Dear Community,

I need your help, may somebody have solution for my question.

I would like to do the following: I have different key values from 01 to 12. Each catory should have a circle with certain colour. I have found different solutions (see below). One solution ist to work with the hard coded coloured unicode circles like yellow (

128993), red (128308) and so on. I have found as well some other community discussions which have solutions with the switch function, but all this solutions use hard coded unicode circle like mentioned before.

That was my first try with a measure. Then I made some other with caluclated columns like DAX code below:

Hardcode Unicode Circles =

SWITCH(

z_StringsBauphaseSperrart[SperrartValue],

"01", UNICHAR(128308),

"02", UNICHAR(128993),

"03", UNICHAR(128308),

"04", UNICHAR(128993),

"05", UNICHAR(128308),

"06", UNICHAR(128993),

"07", UNICHAR(128309),

"08", UNICHAR(11044),

"09", UNICHAR(128309),

"10", UNICHAR(11044),

"11", UNICHAR(128309),

"12", UNICHAR(11044),

"xx"

)

 

The solution above is not too bad, but is not the solution I am would like to receive. Like in different discussion found, the circle unicode 11044 is a black circle, but the colour can be manipulated over the font setting. But, unfortunately there is no conditional formatting where I could put a measure in. Therefore, my thoughts are that there must be a possibily to manipulate the filling of these circles as well over DAX. I have tried a "stupid" solution with format which of course did not work. Below you see a snap out of a DAX-Code.

Links to discussions I have found in the community:

- Power BI Desktop/DAX – Using Unicode (Arrows) as M... - Microsoft Power BI Community

- Solved: UNICHAR: Green Up-arrow and Red Down-arrow - Microsoft Power BI Community

- Solved: unichar with color - Microsoft Power BI Community

...

"01", FORMAT(UNICHAR(11044), "#EB0000")

...

Below you see my different tries:

Now, does somebody know how to colour the black circle (11044) with Dax Code in Table in Power BI. What I also noticed is that unicode is read like text because you can change the filling of the circles over the text font settings. Is there any code solution where I can set the font settings with DAX or other methods?

Don't hesitate to ask if wrote the description to scripted. 😄 

Thanks for our help.

Best regards,
Mike

[Anonymous]

Dear Community Support Team

Thank you very much for your support. Last piece of the puzzle was the conditional formatting which I did not find. I used know the already existing measure and put it in the conditional formatting space, works now perfectly fine.

Best regards,
Mike_CH

[v-xiaotang · Accepted solution]

Hi @Anonymous 

Thanks for reaching out to us.

>>Now, does somebody know how to colour the black circle (11044) with Dax Code in Table in Power BI.

You can try this setting,

or use conditional formatting, Apply conditional table formatting in Power BI - Power BI | Microsoft Docs

conditional formatting = IF(MIN('Table'[Column1])="02","Green")

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.