Forum Discussion
Bug: Conditional formatting is filled with a solid color when all values are blank/0
I am using conditional formatting (scales) on a table. When I slice my data in a way that results in all values in the column to be blank, the conditional formatting uses the darkest version of the color. I would expect it to be white/blank. Is there a workaround?
Example: here is my pipeline table that has dollar values at each stage by sales person, and I have it sliced so there are no dollars for "Gain Commitment". That column should be white (like other $0 cells such as the last one for "Build Value"). This happens if the values are all zeros, or all blanks (as below).
1 Reply
- Eric_ZhangMicrosoft Employee
Thanks for your reporting.
I can reproduce that behavior. I think the reason can be explained, when all 0 or blank, the "Highest value" is 0 or blank, so it shows darkest color, when there's other value than 0, the 0s show the lightest color.