How to write traffic light script ?

[Anonymous]

Hi All

Today i have try to modify the below table report , and when i put back the Variance % , the traffic light colour reset , and i need to set up again. Since i have many table , and i want to change the traffic light from Rule base to script base :-

if Variance >50% Yellor Color

if Variance >10% and <50% Green Color

if Variance <10% Red Color

Hope that some one can help me write the script.

My PBIX file :-

https://www.dropbox.com/s/wml3gzffts2ak4q/preWebinarPostCal_PY_DATA%20V008%20Working%20%283%29.pbix?...

[themistoklis · Accepted solution]

@Anonymous 

Put the following formula in a measure and then add it in the conditional formatting (using field value).

Background Color 1 =
VAR _variance_per_country =
    CALCULATE ( [Variance %], ALLEXCEPT ( 'order', 'order'[Customer Id] ) )
RETURN
    SWITCH (
        TRUE (),
        _variance_per_country < 0.2, "#D64550",
        _variance_per_country < 0.5, "#E8D166",
        _variance_per_country <= 10, "#79FF00",
        "#00000"
    )

[Anonymous]

Hi Sir

Thank you so much , it work fine now .