Conditional formatting not showing when drill up in matrix visual

Hi Anonymous ,

Thanks for the clarification. Since you're using a DAX measure for conditional formatting, the issue likely stems from how the measure behaves at different hierarchy levels.  Your measure Sell Through Variance to Target_Cond = COALESCE([Total Fcst ST% At New Retail] - ([Target ST] / 100), 0) might not be aggregating as expected when the matrix rolls up.

1. Add the measure to a visual and verify its output when rolled up, if it's blank or zero, formatting won’t apply.
2. It can help maintain consistent context across hierarchy levels if the current measure isn't behaving as expected.
3. Ensure your color scale or thresholds handle all possible values (negatives, blanks).
4. Subtotals or default formatting might override conditional formatting check the matrix Format pane.

I hope this help.....