Forum Discussion
Matrix Conditional Formatting when all values are zero
Hi Anonymous ,
You can create the following rule for Outreach column:
Or you can also unpivot other colums, then the matrix will recognize zero as a minimum.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. 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.
Before I attempt your second suggestion, does your first suggestion allow the use of color scale formatting or only rules-based color coding?
Hi Anonymous ,
I used color scale formatting for the referral column and only rules-based color coding for the Outreach column in my first suggestion.
Best Regards,
WinnizThank you. Unfortunately neither of these solutions work for me, as I need the color scaling to be applied to Outreach only (in this example), and not the entire table as a whole. Even if I unpivot the columns, my measure will still be filtering on the Outreach attribute, which will still result in all zeros (occasionally, depending on the date range).
It's the behavior of the color scaling in the conditional formatting that's the issue, which is set to use the maximum color value instead of the minimum color value when all values are the same, in a column.