Forum Discussion
KPI card so buggy with Conditional Formating the Percentage format colors
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
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!
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!
6 Replies
- parry2k
Super User
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 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!
- parry2k
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!
- 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!