KPI - indicator < 3% is GREEN not, RED

[Anonymous]

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

[v-juanli-msft · Accepted solution]

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]

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

[Anonymous]

Hei Maggie,

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

Best regards

Ramirenter