How to Add Subtotal in Power BI
- George Apostolov
How to Add Subtotal in Power BI: step-by-step guide
Select your data and go to the 'Visualizations' pane. Select the 'Matrix' chart.
Go to the 'Format' pane.
Turn 'Column Subtotals' ON.
Turn 'Row Subtotals' ON.
Power BI automatically adds subtotals for the Row and Column groups.
Quick answer: To add subtotals in Power BI, select your data, choose the Matrix chart in the Visualizations pane, navigate to the Format pane, and turn both Column Subtotals and Row Subtotals ON to automatically display them for your groups.
About this Power BI tutorial
Calculate and display row and column subtotals easily by turning on these settings within the format pane of your matrix chart in Power BI. This guide shows how to add Subtotal in Power BI in 5 steps, starting with "Select your data and go to the 'Visualizations' pane. Select the 'Matrix' chart" and finishing with "Power BI automatically adds subtotals for the Row and Column groups". The interactive demo above is a click-through copy of the real Power BI interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to add Subtotal in Power BI?
5 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Power BI data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Power BI. Related guides: How to Add Text to Power BI, How to Add Current Date in Power BI and How to Add Timeline in Power BI. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
