Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to write traffic light script ?

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 c...
Need Help
  • themistoklis's avatar
    themistoklis
    5 years ago

    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"
    )

     

themistoklis's avatar
themistoklis
Community Champion
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Sir

    Thank you so much , it work fine now .