# How to Add Grand Total in Power BI

> To add a grand total in Power BI, open your report, select the table visual, and navigate to the Format icon in the Visualizations pane. Next, select the Totals section and toggle on the values option to enable the total for numeric columns by default.

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

## Steps

1. Open your Power BI desktop and navigate to your report.
2. Select the table visual.
3. Go to the 'Visualizations' pane and click the 'Format' icon.
4. Select the 'Totals' section.
5. Toggle on the values option to enable the total.
6. Once enabled, it will show the total by default for numeric columns.
