Ability to Hide Rows in Matrix Without Affecting Totals

Currently, in Power BI, if you filter out a row in a matrix visual, its values are excluded from totals and other calculations. This creates challenges when you want to hide certain rows (e.g., blanks or intermediate categories) for presentation purposes but still keep their contribution to totals.

Proposed Enhancement:

• Add an option in matrix visuals to hide rows without removing their data from aggregations.
• Allow users to mark rows as “hidden” while totals and grand totals remain accurate.
• Optionally, provide a toggle for “Adjust layout automatically” so the matrix resizes and recalculates visual space when rows are hidden.

Benefits:

• Cleaner reports without losing data integrity.
• Better control over presentation for executive dashboards.
• Avoid complex DAX workarounds (BLANK() measures, conditional formatting).