Forum Discussion
Inserting Subtotals in a Table
Use a Matrix but make it look like a Table
Put your detail fields (Customer, Document No., Line, Item, …) in the Matrix Rows
Put Total_Sales in Values
Put Location as the first row level (above the details)
Turn on Subtotals for Location
Then format it to look like a Table:
Row headers: Stepped layout = Off
Subtotals: On (only for Location)
Gridlines / outline: adjust to match your table style
I would add to the steps that cengizhanarslan suggestes to use the Outline or Tabular formatting in the matrix visual. This was the game changer for our team. This is under the format pane:
Hi Principiante
Think of a Power BI table visual the same way as an Excel table—you only get a single total row. As others have already pointed out, the closest alternative is to use a Matrix visual in tabular layout.
Just keep in mind that sorting in a matrix is hierarchy-aware. For example, if Customer is a higher-level field and Document No is beneath it, sorting the visual by Document No will only sort those values within each Customer, not across all customers globally or across the whole visual.