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 relation to each other for each branch, so f.e. 
branch 1: team 1: (2/5 - green), team 2: (3/5 - yellow) and branch 2: team 1: (1/3 - green), team 2: (2/3 - red)
But I do not want to set in relation to the occurences of all teams, but to itself, so the specific team.
f.e. branch 1, team 1: (2/3- red), because team 1 has 2 incidents in branch 1 and 1 in branch 2.
But somehow my KPI (unichar with conditional formatting) is to unflexible to achieve that.

 

I would be grateful for any help.

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.

2 Replies