Conditional Formatting Greater Than?

[edhans]

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.

[PaulDBrown]

You can actually simply delete the "and is less than" value and it will default to "Max".

[edhans]

Yeah, I know. This thread is over 4 years old now...

[MahyarTF]

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.

[teylyn]

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...

[itskool]

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 😄

[kjimenez]

Thank you very much! The answer was really straightforward but I would never have found it on my own. 

[RMDNA · Accepted solution]

@edhans,

No, there's no way to just have "Greater Than" but thankfully it's only a minor annoyance.

[kjimenez]

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.