KPI card so buggy with Conditional Formating the Percentage format colors

[Anonymous]

Hi,

Can someone else look at this and see if I am missing something. Or is there a better option for a KPI card besides the Native one?

In the KPI card I want to show the percentage change from last year to be either, Red if Negative, Green if Positive. When I change the slicer from "1" to a different number "7" this Rule doesn't update with the direction of the +/-

 

Under "Goals" in the visual format I try and add a conditional formating "Rule" that works, but when I change the slicer from "1" to a different number "7" this rule doesn't update with the direction of the +/-

So the only fix is when I manually go into the "Font Color - Goals" and Hit the "Reverse Color Order" Then it updates on number 7 to be the Correct Green color for a positive.  Is there a better KPI or a solution to this? Thanks!

Trevor

 

[parry2k · Accepted solution]

@Anonymous What is CR LY  measure, is this the measure showing difference %? If not then you need to calculate the difference % and then use that for the conditional formatting.

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

[parry2k]

@Anonymous glad it worked out. Cheers!!

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

[parry2k · Accepted solution]

@Anonymous yes found a way, see video, weird though

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

[Anonymous]

Excellent!! Thanks so much looks like that did the trick. Appreciate it  🙂

[parry2k]

@Anonymous good to hear that your problem is solved, I will look into decimal, maybe some settings on the formatting pane. Do subscribe to my YouTube channel, I will be sharing some interesting Power BI related contents there, link below. Cheers!!

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

[Anonymous]

Thanks!!! That was driving me crazy looking at it.  Something simple. Thanks for additional eyes, that did the trick. 

Do you know how to get rid of the decimals in the % change in these KPI cards? Thanks again

[parry2k · Accepted solution]

@Anonymous What is CR LY  measure, is this the measure showing difference %? If not then you need to calculate the difference % and then use that for the conditional formatting.

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!