Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

danextian

Power BI Conditional Formatting Logic

Submitted by Super User on ‎11-14-2019 06:48 PM

Hello,

 

Please check on this. "Is greater than or equal to minimum" and "is less than 0" is a valid logic but Power BI won't accept it unless  I change 0 to something like 0.0000001. Re-editing the logic reverts 0.0000001 back to 0.  Please see attached image.2019-11-15 09_17_53-Window.png

Status: New
See more ideas labeled with:
4 Comments (4 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎11-17-2019 06:46 PM

Hi @danextian, 

 

Wha't your Power BI desktop version? 

 

Based on my test in Power BI desktop version 2.75.5649.582 64-bit (November 2019), it's able to define the icon rule with "Is greater than or equal to minimum" and "is less than 0". See: 

 

q1.PNG

 

Best Regards,
Qiuyun Yu

danextian
Super User
Super User
‎11-17-2019 11:53 PM

Hello,

 

I am using the November 2019 version. It's kinda weird that your screenshot is showing a dropdown for Number/Percentage but mine is not.

v-qiuyu-msft
Community Support
Community Support
‎11-18-2019 11:34 PM

Hi @danextian, 

 

What's your Power BI desktop version number? Mine is version 2.75.5649.582 64-bit (November 2019). 

 

Best Regards,
Qiuyun Yu

danextian
Super User
Super User
‎11-19-2019 11:51 PM

Hi @v-qiuyu-msft 

 

We do have the same version.

Idea Statuses