Forum Discussion
Helper IConditional Formatting: wrong individual format
I am using conditional formating in a table. For some reason that single cell just turns dark blue because it thinks it's a maximum value in that range. Any thought why this could happen ?
KBUIUS that is the issue, conditional formatting is using sum of net loss but in visual you are showing non summarize data, and that is the problem. You are working with two different numbers.
✨ Follow us on LinkedIn and to our YouTube channel
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.
8 Replies
- AlexisOlson
Super User
This is my thought as well.
KBUIUS In other words, are you formatting the column using the same measure as you're showing in that column?
KBUIUSThat's the column Net Loss
- parry2k
KBUIUS that is the issue, conditional formatting is using sum of net loss but in visual you are showing non summarize data, and that is the problem. You are working with two different numbers.
✨ Follow us on LinkedIn and to our YouTube channel
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.
- KBUIUS
so how can I apply Conditional Formatting on the "raw" data without any calculation?
- parry2k
KBUIUS conditional formatting can only use based on the summarized data, maybe instead of SUM use MAX as an aggregation method.
✨ Follow us on LinkedIn and to our YouTube channel
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.
