Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

KPI - indicator < 3% is GREEN not, RED

Hey people,

 

I have a question how do I need to set up the "Target goals" so that everything under 3% is actually GREEN, not RED. I tried to set the target goals as a simple measure, "KPI target = 3", but as my Exception % actual value is 2.52, then it is considered as BAD, whereas it is good.

And is there a possibility to exclude the trend axis part, as I only need to check if this value is green or red, not conveying the picture of change over time. 

 

Jaanis

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    You can turn off the "trend axis" from the "KPI' visual.

    If you'd like to show a single value om a card and its color based on the target.

    you could use "Advanced card".

    Create a measure used in "condition" field.

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous 

    You can turn off the "trend axis" from the "KPI' visual.

    If you'd like to show a single value om a card and its color based on the target.

    you could use "Advanced card".

    Create a measure used in "condition" field.

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hei Maggie,

       

      Thanks for the reply! This is sounds perfect and will do the trick! 🙂

       

      Best regards

      Ramirenter

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi,

       

      v-juanli-msft 

       

      I tried to Advanced Card, and it does the trick, I do not need to use trend, which is super nice. 

      BUT I have some issues with the card. Currently regardless on the filters I'm using and even though, the Data Field value I'm using changes the underlying foreground and background color is not changing.

      I'm using there a measure below:   

       

      Status_System Exception = (CALCULATE(COUNT(Sheet1[Status Combined]);Sheet1[Status Combined] = "System Exception"))/COUNT(Sheet1[Id])
       

      Below is a snip of the value, which by color should be white, but background should be RED. But, in reality the background color hasn't changed.

      Setup of the conditions can be seen below.

      I have also tried to mark the foreground color as GREEN if value is ❤️ and if value is >3, then RED. Then it was the same, that the overall measure value was 2,52, which would mean the color coding to be GREEN, but if I choose P002 with value 4,14, then it was also GREEN, allthough it should be RED.

       

      Hope you can help.

       

      Ramirenter