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 colour coded it, but it doesn't look quite right for our purposes. We have data that spans a few years so we'd like it to change dynamically, hence why we can't simply use static values. 

We'd like to see the card turn green when it's above the budgetted value (previous year is irrelevant!), yellow when it's below budget but above the previous year and red when it's below both. Currently the red colour works fine, but sometimes the KPI is yellow when we'd like it to be green. This occurs when the value is above budget but below the previous year. We can't seem to find an option in the colour coding tab that lets you fix this issue.

Does anyone have any ideas?

 

Regards,

Jasper

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. 

7 Replies

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