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

This is an example of one of the snapshots with the wrong colour coding. 

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

Hi Anonymous ,

 

Have you configure right in the color coding?

 

Would you please show us sample pbix with the issue?

 

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

    I have, the main issue is in the fact that it isn't as simple as "high is good", "low is bad". The issue is in the yellow middle ground where I'd like to change it to green when actual is above target (TGT) but below PY. It should stay yellow when it's below target but above previous year (PY). Or in other words: 

    ACT>TGT & PY = Green
    PY>ACT>TGT = Green
    ACT < TGT & PY = Red
    PY < ACT < TGT = Yellow

     

    On the image I added you can see that it turns yellow when it's above target, which is not what I'd like to see. 


    I figured it would be possible in conditional formatting but I can't seem to find any options to change this. I can only use rules with static values I have to input myself and that does not seem to work for my purposes. 

    I can't seem to attach a file unfortunately but I think it's a fairly straight forward issue. The image shows my problem and I haven't really tinkered with the KPI setting at all.

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

      Hi Anonymous ,

       

      As far as l know, the build-in kpi visual could have only one target value. how do you contain two target in your kpi visual and compare them?

       

      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 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