How to create background color or icon of a value in cell

[SelflearningBi]

Please help, I got such cell. I would like to use green color and icon to ON TIME. Dark red to 4 weeks +, and light red to 4 weeks and so on...
I found the conditional background or icon only avaiable to value and count/distinct count, not sure how to deal with word, like ON TIME,  1 WEEK, 2 WEEK

[truptis]

Hi @SelflearningBi ,

You can try conditional formatting on background colours & icons.
step 1 - create a column such that if postone status = "1 week" then 1, if "2 week" then 2 and so on... then click on fx(screenshot)

and then put the conditions of colours(screenshot):

You can also refer this for logic purpose: https://community.powerbi.com/t5/Desktop/Dynamic-Card-Visual-s-Color/m-p/2400119#M861023  

@SelflearningBi -> Please hit the thumbs up & mark it as a solution if it solves your query. Thanks. 

[v-jingzhang · Accepted solution]

Hi @SelflearningBi 

You can create a measure with color hex codes for conditional formatting. For example, 

color =
SWITCH (
    SELECTEDVALUE ( 'Table'[Postone Status] ),
    "ON TIME", "#66cdaa",
    "4 WEEKS+", "#aa0022",
    "4 WEEKS", "#ee3355"
)

When setting up the conditional formatting, select Field Value for Format style and select above measure for "What field should we base this on?"

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.