How to Add Grand Total in Power BI
- George Apostolov
This guide is an interactive LiveDemo. Create interactive demos of your own product: Interactive demo software · Interactive customer onboarding guides · Start free
How to Add Grand Total in Power BI: step-by-step guide
Open your Power BI desktop and navigate to your report.
Select the table visual.
Go to the 'Visualizations' pane and click the 'Format' icon.
Select the 'Totals' section.
Toggle on the values option to enable the total.
Once enabled, it will show the total by default for numeric columns.
Quick answer: 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.
About this Power BI tutorial
Enable grand totals for numeric columns in your Power BI table visuals by toggling the option on within the Format section of the Visualizations pane. This guide shows how to add Grand Total in Power BI in 6 steps, starting with "Open your Power BI desktop and navigate to your report" and finishing with "Once enabled, it will show the total by default for numeric columns". The interactive demo above is a click-through copy of the real Power BI interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to add Grand Total in Power BI?
6 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Power BI data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Power BI. Related guides: How to Add Graph in Power BI, How to Add Images to Power BI and How to Add Multiple Tables in Power BI. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today





