# How to Add Total in Power BI

> To add totals in Power BI, open your desktop report, select the table visual, and open the Format icon in the Visualizations pane. Next, expand the Totals section and toggle the switch to On to enable sum calculations for your numeric columns.

Canonical: https://livedemo.ai/tutorials/how-to-add-total-in-power-bi/
Apps: Power BI
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a2f23d673bd5aa8e614d6/preview?step=1

## Steps

1. Open your 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 on 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. You'll now see totals appear at the bottom of your numeric columns. You can further customize how they display in the formatting options.