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.
Solved! Go to Solution.
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.
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...
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.