How to Add Total in Power BI

Quick summary

Adding totals in Power BI lets you display sum calculations at the bottom of a table visual with just a few clicks in the formatting pane. This guide walks you through enabling the Totals toggle inside the Visualizations panel so your numeric columns automatically aggregate.

Steps

1. Open Power BI Desktop and load the report you want to add totals to.
2. Click on the table visual that needs totals.
3. In the Visualizations pane on the right, click the Format icon (paint roller) to access the formatting options.
4. Scroll down in the formatting menu until you find the Totals section and click to expand it.
5. Toggle the On switch for Totals to enable sum calculations.
6. Review the totals row now visible at the bottom of your numeric columns, then further customize their display in the formatting options.