How to Add Total in Power BI
- George Apostolov
- 05 Sep 2025
Guide
Open your Power BI desktop and load the report you want to add totals to.
Click on the table visual that needs totals.
In the 'Visualizations' pane on the right, click on the 'Format' icon (paint roller) to access the formatting options.
Scroll down in the formatting menu until you find the 'Totals' section and click to expand it.
Toggle the 'On' switch for 'Totals' to enable sum calculations.
You'll now see totals appear at the bottom of your numeric columns. You can further customize how they display in the formatting options.
Create your first interactive demo in minutes
No credit card required • Start building today


