Forum Discussion
Conditional Formatting for values not equal to 0 is not working properly
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 highligh...
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.