Forum Discussion
Matrix Conditional Formatting when all values are zero
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,
Winniz
If 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.