Forum Discussion
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.
- Add the measure to a visual and verify its output when rolled up, if it's blank or zero, formatting won’t apply.
- It can help maintain consistent context across hierarchy levels if the current measure isn't behaving as expected.
- Ensure your color scale or thresholds handle all possible values (negatives, blanks).
- Subtotals or default formatting might override conditional formatting check the matrix Format pane.
I hope this help.....
Thank you V-yubandi-msft anilelmastasi , I'm using Dax Measure as below and conditional formatting as below
and conditional format is
Please help here ..
Community SupportHi 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.
- Add the measure to a visual and verify its output when rolled up, if it's blank or zero, formatting won’t apply.
- It can help maintain consistent context across hierarchy levels if the current measure isn't behaving as expected.
- Ensure your color scale or thresholds handle all possible values (negatives, blanks).
- Subtotals or default formatting might override conditional formatting check the matrix Format pane.
I hope this help.....