Apply rule using conditional formating

[Zakaria_1980]

Dears,

i've the below table for which i need to apply rule (see 2nd screenshot). i'll need in my table under column Status, when the status is:

Late ==> it will display Late & next to it flag in Red

In Progress==>it will display In Progress & next to it flag in Orange

Closed==>it will display Closed& next to it flag in Green.

Thanks in advance.

[adhumal2]

@Zakaria_1980: This solution will help you 

https://community.powerbi.com/t5/Desktop/Conditional-Formatting-for-negative-values-with-3-condition...

[Pragati11 · Accepted solution]

Hi @Zakaria_1980 ,

Did you try checking ICON FORMATTING in Power BI?

You can refer following blog for the same:

https://www.c-sharpcorner.com/article/apply-conditional-formatting-for-a-text-column-using-icons-in-...

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[amitchandak]

@Zakaria_1980 , you have an icon option ins conditional formatting explore that

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

Or use your own

https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

You can create measure and do that

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[Zakaria_1980]

i don't succeed to do it through the links you have shared with me. could you please take the below example and send me the power bi report to undestand better how it is doable.

Thanks