Forum Discussion
Conditional Formatting Greater Than?
Am I missing sometiing or is there no way to have conditional formatting Greater Than only?
I am using "Color by rules" and if I select "greater than (or equal to)" I seem to be required to fill in the "and is less than" with some fake 9999999999 number.
I have the June 2018 desktop version.
8 Replies
Actually, there is a way to have just Greater Than. Just remove any number from the Greater Than box. That's it.
Chris Webb has it written out in this blog: https://blog.crossjoin.co.uk/2019/07/04/greater-than-less-than-rules-power-bi-conditional-formatting/
Thank you very much! The answer was really straightforward but I would never have found it on my own.
Thanks for this! I've been using the dummy 1111111111111111 number for a couple of years now, but I have a training for users in my company next week and I felt this wouldn't help with the adoption 😄
You can actually simply delete the "and is less than" value and it will default to "Max".
Yeah, I know. This thread is over 4 years old now...
It is not a "minor" annoyance, it is really important. And there is a way to do this; as teylyn brilliantly said, we just need to remove any number from the Greater Than box.
Hi,
You could put the particular value as a greater than or equal and delete the value for the other Less than, but it is considering the number for the less than value automatically.
