LiveDemo - Open-source alternative to Storylane, Navattic, and Arcade | Product Hunt

How to Add Grand Total in Power BI


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

  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.

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.

LiveDemo - Open-source alternative to Storylane, Navattic, and Arcade | Product Hunt
🚀

Create your first interactive demo in minutes

No credit card required • Start building today

Start free→