cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
edhans
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
1 ACCEPTED SOLUTION
RMDNA
Solution Sage
Solution Sage

@edhans,

 

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

View solution in original post

3 REPLIES 3
MahyarTF
Solution Sage
Solution Sage

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.

MahyarTF_0-1658273641661.png

 

teylyn
MVP

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

RMDNA
Solution Sage
Solution Sage

@edhans,

 

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

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors