Conditional Formatting for values not equal to 0 is not working properly

[zyeet]

I am trying to highlight the Discrepancies in my data where the values not being equal to 0 should be highlighted red. But the problem is that some rows that have the value 0, are also being highlighted.

The rule I wrote is:

The Conditional formatting shows up like this:

[WranglerPro_BDT]

Found a workaround and hope this is helpful: 

Pick a color for zero, then set the same colour for a range that accomodates rounding errors: MIN (-0.01) and MAX (0.01) 

Then pick the colour you want for reconciling items and start from the boundaries set for zero so it looks like this:

[Anonymous]

Hi @zyeet 

Based on the information you provided me, I think the problem may be in -1e+3!, you can change it to a numeric type like -1000 so that there is no problem associated with it.

1. Turn -1e+3! into -1000.

     2. All 0.00 are become the same color.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[zyeet]

I have tried your solution but not all my 0's are being formatted green:

You can check the pbix file here:

Draft Comparison Report.pbix

[Anonymous]

Hi, @zyeet

Based on the information you have provided, Here are my answers to your questions.

I opened your pbix file and found that there were indeed some 0.00s that didn't meet the green condition, so I rewrote a Color's Measure that returns green when the value of Variance is not equal to 0, and what I got was also that there were a lot of rows of 0.00s that turned green, which indicates that these values are not equal to 0.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jihwan_Kim]

Hi, I am not sure how your semantic model looks like, but please try using ROUND DAX function whether it suits your requirement.

ROUND function (DAX) - DAX | Microsoft Learn