Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
danextian
Super User
Super User

Power BI conditional formatting logic not being accepted

I am not sure if this is a bug or what. I could make the logic work in the previous version of Power BI but now that I have installed the Nov 2019 release, it just won't accept it. Isn't "greater than or equal to minimum" and "is less than 0" a valid logic. I had to input a decimal number that is almost 0 (like 0.0000000001) to make it work and when I tried to edit the logic again, the number returned to 0 instead of the decimal number i initially inputted. 

2019-11-15 09_17_53-Window.png










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
1 REPLY 1
venal
Memorable Member
Memorable Member

@danextian 

I tried to re-pro the issue from my end with the older version of the Power BI Desktop (Aug-2019).

 

Even though if we give decimal number also it is going to convert to number.

Ex:- 1000.85 -> 1000

After that i tried to re-pro it with decimal like below. But having the same issue, after refresh it got changed from decimal to number.

Conditional Formatting-Testing.JPG

 

Conditional Formatting-Testing-1.JPG

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.