Forum Discussion
Conditional Formatting for values not equal to 0 is not working properly
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.
- 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.
I have tried your solution but not all my 0's are being formatted green:
You can check the pbix file here:
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.