Power BI Matrix Column Hierarchy

Hi   

• In a Matrix, column hierarchies are rendered top-down.

• At the Grand Total (Year) level, Power BI collapses lower column levels (Quarter → Sale Type).

• Power BI does not repeat or display child column headers (like Sale Type) when the parent level (Year) is fully aggregated.

• This is by design and currently cannot be changed via formatting.

  That’s why

  • Sale Type appears under Quarter

  • Sale Type disappears under Year (Grand Total)

    Workarounds you can use

    1)Move Sale Type higher in the column hierarchy

    Reorder columns

    Year → Sale Type → Quarter

    This forces Sale Type to be visible even at higher levels.

    Changes how users drill and read the matrix.

     

    2)Disable column subtotals

    • Go to Format → Subtotals

    • Turn Column subtotals = Off

      This removes the Year total entirely, avoiding the confusing layout.

      Best when totals add limited value.

      3)Use Field Parameters for columns

      Create a Field Parameter allowing users to switch between

      • Year view

      • Quarter + Sale Type view

        This gives explicit control instead of auto-aggregation.

        4)Duplicate visuals

        • One matrix for Year totals

        • One matrix for Quarter + Sale Type

          Use bookmarks or toggles to switch between them.

          What is NOT possible

          • Showing Sale Type only in Grand Total header

          • Forcing Matrix to repeat child headers at total level

          • Custom formatting of matrix column headers at different hierarchy depths