Forum Discussion
Conditional formatting not showing when drill up in matrix visual
Hi Folks, Looking for help ..I have matrix visual with conditional formatting , is getting effected when i drill down as 1st pic but when drill up (rollled up) is not showing condtional format as 2nd pci..looking for great
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.....
7 Replies
V-yubandi-msftCommunity Support
Hi Anonymous ,
Thank you for engaging with the Microsoft Fabric Community. The issue where conditional formatting appears during drill down but disappears when rolling up is usually caused by applying formatting to a raw column instead of a DAX measure.
To ensure conditional formatting works consistently across all hierarchy levels in a matrix visual, the formatting must be applied to a DAX measure. This allows Power BI to evaluate the logic dynamically based on the current context whether you're drilled down or rolled up.1. Create a DAX measure that calculates the value you're using for conditional formatting (variance %).
2. Apply conditional formatting using this measure, not a raw column or field.
Helpful Reference: Apply conditional table formatting in Power BI - Power BI | Microsoft Learn
Thanks you for your response anilelmastasi .
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
- anilelmastasi
Super User
Hello Anonymous ,
Is your conditional formatting is applied on a measure or a raw column?
Thank you V-yubandi-msft anilelmastasi , I'm using Dax Measure as below and conditional formatting as below
Sell Through Variance to Target_Cond = COALESCE( [Total Fcst ST% At New Retail] - ([Target ST] / 100 ),0)
and conditional format isPlease help here ..
- V-yubandi-msft
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.....
- V-yubandi-msft
Hi Anonymous ,
We noticed we haven't received a response from you yet, so we wanted to follow up and ensure the solution we provided addressed your issue. If you require any further assistance or have additional questions, please let us know.
Your feedback is valuable to us, and we look forward to hearing from you soon.
- V-yubandi-msft
Hi Anonymous ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
- V-yubandi-msft
Hi Anonymous ,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
