How to get conditional formatting (or icons) to work in a table for text values.

[Anonymous]

How can I get conditional formatting (or icons) to work in a table based on one of say, three selected text values? I have followed every tutorial I could find but I either get no change or the broken image icon when I try to use the canned icons option. 

Virtually everything in Power BI is driven by financials (i.e. numbers) but there are other areas (such as clinical trials), that need to be reported on by things such as status, time to complete, etc. 

[KerKol · Accepted solution]

Hello there,

You can use unicode or conditional icons for text strings within a matrix.

For example, unicode measure could look something like this:

For conditional icons, you could go a similar solution by setting "Accepted" and "Rejected" as 1, 0, then conditionally formatting based on these numbers:

[Anonymous]

The problem with unicode characters is they are not consistent across browsers and OS's. Also, there is no option to reuse the same shape in different colors. I.e circles in blue, green, red and orange. 

[KerKol]

Yes, that is a problem with unicode 🙂

 

[amitchandak]

@Anonymous , 1. You can icon conditional formatting

2. You can create an icon measure and color meausre. Icon will unichar and you will add that as measure in value and then use color to do conditional formatting using filed value option

example

/////Arrow
Arrow =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, UNICHAR(9650),
_change = 0, UNICHAR(9654),
_change < 0, UNICHAR(9660)
)

/////Arrow Color
Arrow color =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, "green",
_change = 0, "blue",
_change < 0, "red"
)

refer these if needed

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

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

[Anonymous]

You are showing how to do it based on numeric values. I need to do so based on text values. 

Example: There is no way to show a green unicode shape like a circle for a status of "Accepted", a yellow circle for "InProgress" and a red circle for "Rejected", etc.