Forum Discussion
Matrix Conditional Formatting when all values are zero
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,
Winniz
Thank 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.
Hi Anonymous ,
Try to customize the minimum and maximum values, where the minimum value is 0.
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,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This does not solve my problem because the maximum values are not known. I would still like the largest values to be dark-colored, and the smallest values (zeros) to be light-colored.
If all values become zero, the color displayed is darkest, not lightest, which is not desirable.
Hi Anonymous ,
Does your problem have been solved? If it is solved, please mark a reply which is helpful to you.
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,
WinnizThis does not solve my problem because the maximum values are not known. I would still like the largest values to be dark-colored, and the smallest values (zeros) to be light-colored.
If all values become zero, the color displayed is darkest, not lightest, which is not desirable.