Forum Discussion
Conditional Formatting with percentages - Help
I want to highlight how some percentages are lower (meaning a bad thing) but it doesn't look like conditional formatting will allow me to make a rule that goes if percentage is this amount then go red icon - because it sums the value which is not what I want.
3 Replies
Hi agd50 ,
Would it work if you write 0.33 instead of 33, and 0.67 instead of 67 and so on in your conditional format settings?
Let me know 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/I thought of this too, I will give it a go and let you know.
Looks like the field you are using is a column.
You need to create a measure for % calculation and then use that measure as filed, as measure is summarised by default and only returns one value, power bi will not ask you to do summarization.
