Forum Discussion
Conditional formatting with symbols - Negative values
Hi all,
I have a question about conditional formatting with symbols. I would like to apply this to a % variance in particular a negative variance so -3% to +3% is green. However, I can't display this and I get a negative entered value directly outlined in red and I can't apply this. What is the reason for this? There are deviations in the negative range after all. I also can not enter: is equal to 0 and less than -3% e.g. Anyone has any idea here?
Thank you and many thanks for the response.
Regards,
Ahsan
Anonymous if you have already calculated a percent in a measure, change percent to number and change value -3 to -0.03 is 3%, and so on .
✨ Follow us on LinkedIn
Check 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!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
2 Replies
- parry2k
Super User
Anonymous if you have already calculated a percent in a measure, change percent to number and change value -3 to -0.03 is 3%, and so on .
✨ Follow us on LinkedIn
Check 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!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- v-luwang-msft
Community Support
Hi Anonymous ,
Check that the places I have red-lined are correctly adjusted.The left side of the image below shows the result of the rule being used successfully.
Wish it is helpful for you!
Best Regards
Lucien
