Conditional Formatting based on Color code logic

[Anonymous]

Hi Experts,

I'm facing challenge while creating a KPI's dashboard.

As per Business requirement I need to apply color code for KPI's as per below logics for 

- Green: when is equal or below to the target. Amber: Above 5% of the target. Red: Above 10% of the target

and 

- Green: when is equal or above to the target. Amber: below 5% of the target. Red: below 10% of the target

Please suggest

[harshnathani]

Hi @Anonymous ,

You can try the below solution

https://community.powerbi.com/t5/Desktop/Conditional-color-formatting-overview/m-p/329137

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Conditional-Formatting/m-p/956261

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

[lbendlin]

Create a calculated column like so:

c = switch(true(),kpi<1.05,"green",kpi<1.1,"yellow","red")

and then use that column in the conditional format "by field value"