Issue with Background color from cell elements

[hemamaleni]

I am having issue with background color when I change it from default value to some other color. I am expecting the highest value from each year to be highlighted with dark color (Ex:2024). The year comes from a different table, Test months come from different table and so the is the % values. No measures used. Anyone faced similar issue?

[hemamaleni]

I do not want to use the formatting style: rule as I have to set defined percentages. Trying to built this report like a heat map and I would like to know why the formatting style: gradient works fine with default color and doesn't when the color was changed.

[Anonymous]

Hi @hemamaleni ,

Apply conditional formatting rules to the cells containing the percentage values. Set up a rule that highlights the maximum value in each row (for each year) with the desired dark color.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.