Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PowerBi KPI traffic light

Hello! I try to build a "traffic light" my data looks somehow like this: team branch number_of_incides 1 1 2 1 2 1 2 1 3 2 2 2   What I already achived, is that I can set the teams in relatio...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous 

    You may try some measure like this for conditional formatting:

    Measure = 
VAR _total = CALCULATE(SUM('Table'[Number_of_Incides]),ALLEXCEPT('Table','Table'[Team]))
VAR _value = DIVIDE(SUM('Table'[Number_of_Incides]),_total)
RETURN
SWITCH(TRUE(),_value>=2/3,"Red",_value>=1/3,"Yellow","Green")

    Kindly let me know if this helps.
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi Anonymous 

You may try some measure like this for conditional formatting:

Measure = 
VAR _total = CALCULATE(SUM('Table'[Number_of_Incides]),ALLEXCEPT('Table','Table'[Team]))
VAR _value = DIVIDE(SUM('Table'[Number_of_Incides]),_total)
RETURN
SWITCH(TRUE(),_value>=2/3,"Red",_value>=1/3,"Yellow","Green")

Kindly let me know if this helps.
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.