How to put conditional formatting on text ?

[Anonymous]

I have this table and I would like to put icons according to the state : 

[Anonymous · Accepted solution]

Hi @Anonymous ,

You could create a measure to use numbers to represent different states.

Measyre =
SWITCH (
    SELECTEDVALUE ( 'table'[state] ),
    "Submitted", 1,
    "New", 2,
    "Rejected", 3,
    "Accepted", 4,
    "Closed", 5,
    "Planned", 6
)

Then use the value of measure to create conditional formatting rule.

Best Regards,

Jay

[AnamPatel]

Click on the Down Arrow in front of the Column Name under Values Tab and Select Conditional Formatting > Icons

A new Icon window will pop up – fill all the details, select the icon type you want and click on OK.

That’s it, the icons will show up on your chart –

[MattAllington]

Read my article here https://exceleratorbi.com.au/conditional-formatting-with-a-text-field-in-power-bi/