Replace the Column Values with UNICHAR CODE Colors

[Anonymous]

Hello All,

Displaying the Status of a some Columns in a matrix table and want to replace it with UNIHCAR code

As you can see above I am having the status such as Completed, In Progress, Blocked .
But I want to display status of the columns with colors using below UNICHAR code as below

Unichar Code for Green :  UNICHAR("128994")

Unichar Code for Yellow:  UNICHAR("128993")

Unichar Code for Red:  UNICHAR("128308") 

Can any one please help me how can I make it

@v-yetao1-msft 
@selimovd 
@Jihwan_Kim 

[v-xiaotang · Accepted solution]

Hi @Anonymous 

As far as I know, in Power BI if you want to replace specific value with Unichar code colors, it’s unrealistic to avoid  creating measures.

Even through conditional formatting using Icons in Power BI,

FYI: https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/

-

Besides, you said “When I use the below expression in calulated column its' working fine but not for measure.”emmm, try this:

AM = 
var  _attri=SELECTEDVALUE(Products[Attribute])
var  _product=SELECTEDVALUE(Products[Value])
return 
IF(_attri = "AM"&&_product = "Completed",UNICHAR("128994"),IF( _attri = "AM"&& _product = "In-Progress",UNICHAR("128993") ,IF(_attri = "AM"&& _product = "Blocked",UNICHAR("128308"),BLANK())))

Result:

See sample file attached below.

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.

[amitchandak]

@Anonymous , You have to create color and unichar measures like

Arrow =
SWITCH (
TRUE(),
Max(status) ="Completed" ,UNICHAR(128994),
Max(status) = ""In Progress, UNICHAR(128993),
Max(status) = ""Blocked, UNICHAR(128308)
)

/////Arrow Color
Arrow color =
SWITCH (
TRUE(),
Max(status) ="Completed" ,"Green",
Max(status) = ""In Progress, "Yellow",
Max(status) = ""Blocked, "red"
)

Use arrow a measure/values and use color in conditional formatting

for more details

https://exceleratorbi.com.au/dax-unichar-function-power-bi/

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
https://youtu.be/M5PvQUy-L_4?t=531

[Anonymous]

Amit,

When I use the below expression in calulated column its' working fine but not for measure.
AM = SWITCH(TRUE(), 'Products'[Attribute] ="AM " && 'Products'[Value] = "Completed" ,UNICHAR("128994") , 'Products'[Attribute] ="AM " && 'Products'[Value] = "In-Progress" ,UNICHAR("128993") , 'Products'[Attribute] ="AM " && 'Products'[Value] = "Blocked" ,UNICHAR("128308")  )

And my client don't want more columns or measures as mine is banking project and there are hundrends of columns .
He just want to replace the value with color