Forum Discussion
Conditional Formatting not working
I have a Matrix visual wherein conditional formatting has been applied on the background. There some filters defined on the report. Conditional formatting is working correct when no filter is appl...
Hi RachnaV ,
You can't apply gradient formatting with automatic maximum/minimum values, or rule-based formatting with percentage rules, if your data contains NaN values. NaN means "Not a number," most commonly caused by a divide by zero error. You can use the DIVIDE() DAX function to avoid these errors.
If the problem is still not resolved, please provide your PBIX file without sensitive data. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.