Forum Discussion

ROG's avatar
ROG
Responsive Resident
3 years ago
Solved

Custom KPI Color in a Power BI

Hi all,
 
I have created the three KPIs below, so I can apply some condition formatting as per below.

KPI colourGreen SIMO&PP = IF([KPI Var SIMO&PP] >=0, 1,0)
KPI colourRed SIMO&PP = IF([KPI Var SIMO&PP] <=0, 1,0)
KPI colourYellow SIMO&PP = IF([KPI Var SIMO&PP] >=0 && IF([KPI Var SIMO&PP] >=0,1,0))
 
Logic: 
GREENOn target or above Budget
YELLOW Between -5% and 0% variance to budget / timing related variance
REDMore than 5% variance to Budget

I added the green and red metrcis into a pie chart, and then on the color formatting, I added the correspondent color as you can see below.



 

 

It works, but the yellow metric is incorrect. Could you please, help em with this one?
 

 

 

Thank you!

Need Help
Show and Tell
Tips and Tricks
  • Padycosmos's avatar
    Padycosmos
    3 years ago
    Hope this helps
    KPI colourGreen SIMO&PP = IF([KPI Var SIMO&PP] >0.05, 1,0)
    KPI colourRed SIMO&PP = IF([KPI Var SIMO&PP] <-0.05, 1,0)
    KPI colourYellow SIMO&PP = IF([KPI Var SIMO&PP] >=-0.05 &&[KPI Var SIMO&PP] <=0.05  ,1,0)

1 Reply

  • Padycosmos's avatar
    Padycosmos
    Solution Sage
    3 years ago
    Hope this helps
    KPI colourGreen SIMO&PP = IF([KPI Var SIMO&PP] >0.05, 1,0)
    KPI colourRed SIMO&PP = IF([KPI Var SIMO&PP] <-0.05, 1,0)
    KPI colourYellow SIMO&PP = IF([KPI Var SIMO&PP] >=-0.05 &&[KPI Var SIMO&PP] <=0.05  ,1,0)