Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

KPI Card Colour Coding with Multiple Goals

I'm currently working on a KPI visual with two goals: the budgetted value & the value from the previous year. The previous year's value was calculated with a measure. Power BI has automatically colou...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi,

    You may not have given me the exact solution I was looking for, but you put me on the right track so thanks for that! I eventually managed to solve it by creating a measure:

     

     IF([ ACT]>[Target ];"Green";"Yellow")

    I added this to conditional formatting on the neutral value and it seems to have worked so thanks for the inspiration. 
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

You can add a second goal by simply dragging your measure or column to the target goal field and put it below the other goal. So I have both my Target Column and PY measure in that data field, and my actuals in the Indicator field. Power BI will automatically colour a KPI with an indicator value between your two goals yellow. It's definitely a useful tool with multiple goals, but it's missing that one step for us at the moment. The conditional formatting pane is a tad confusing in Power BI so I might be missing something, which is why I asked here.

 

Regards,

Jasper

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi Anonymous ,

 

Thank you for explanation. The build-in kpi visual will not compare the indicator with the target value. It will not compare the values between your target values.

 

So in the situations below it will show yellow:

 

PY>ACT>TGT   PY < ACT < TGT 

 

As a workaround, you can use card visual and use the conditional formatting for the data color:

 

 

And create a measure for the color format like:

 

Measure = SWITCH(TRUE(),[ACT]>[TGT]&&[ACT]>[PY],"Green",[ACT]>[TGT]&&[ACT]<[PY],"Green",[ACT]<[TGT]&&[ACT]<[PY],"Red",[ACT]>[PY]&&[ACT]<[TGT],"Yellow")

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi,

    You may not have given me the exact solution I was looking for, but you put me on the right track so thanks for that! I eventually managed to solve it by creating a measure:

     

     IF([ ACT]>[Target ];"Green";"Yellow")

    I added this to conditional formatting on the neutral value and it seems to have worked so thanks for the inspiration.