How to Add Grand Total in Power BI

Quick summary

Adding a grand total in Power BI lets you instantly summarize numeric data across your table visual without writing any DAX. You can enable it in seconds through the Visualizations pane using the built-in Totals formatting option.

Steps

1. Open Power BI Desktop and navigate to the report where you want to add a grand total.
2. Select the table visual on your report canvas.
3. Go to the Visualizations pane and click the Format icon.
4. Scroll to and select the Totals section within the Format options.
5. Toggle on the Values option to enable the grand total row.
6. Once enabled, the grand total will automatically appear for all numeric columns in your table.