Power BI Matrix: conditional formatting icons not showing on row subtotals

Summary

Power BI Matrix: Conditional Formatting Icons Missing on Row Subtotals

Power BI conditional formatting icons disappear on row subtotals in Matrix visuals with hierarchy, a common issue with a targeted DAX solution.

A Power BI user reports that conditional formatting icons display correctly on detail rows but vanish on row subtotals in a Matrix with a two-level hierarchy (Executive Name to Executive Scope). This is a known Power BI behavior: conditional formatting based on specific field values does not automatically propagate to subtotal and total rows. The fix requires a custom DAX measure that detects the aggregation context.

Why This Matters for BI Professionals

Conditional formatting in Matrix visuals is among the most-used features in Power BI reports. The subtotal issue affects anyone working with hierarchical data. Understanding how ISINSCOPE and HASONEVALUE work in DAX context is essential for correct visual rendering across all aggregation levels.

Key Takeaway

Use ISINSCOPE() or HASONEVALUE() in your DAX measure to detect whether you are at the detail or subtotal level, and adjust your conditional logic accordingly.