Forum Discussion
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 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 :-
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" )
2 Replies
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" )