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.

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , You can create color and unichar measure and do based on that

Switch( True(),

Sum(Table[number_of_incides]) <= 2, "Green",

"red"

)

 

Use in conditional formatting using field value

 

Refer for unichar and color

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692
https://www.youtube.com/watch?v=veCtfP8IhbI
https://exceleratorbi.com.au/dax-unichar-function-power-bi/