How to Add 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 Total in Power BI: step-by-step guide
Open your Power BI desktop and load the report you want to add totals to.
Click on the table visual that needs totals.
In the 'Visualizations' pane on the right, click on the 'Format' icon (paint roller) to access the formatting options.
Scroll down in the formatting menu until you find the 'Totals' section and click to expand it.
Toggle the 'On' switch for 'Totals' to enable sum calculations.
You'll now see totals appear at the bottom of your numeric columns. You can further customize how they display in the formatting options.
Quick answer: 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.
About this Power BI tutorial
Enable sum calculations on your table visuals by turning on the Totals option in the Power BI formatting menu. This guide shows how to add Total in Power BI in 6 steps, starting with "Open your Power BI desktop and load the report you want to add totals to" and finishing with "You'll now see totals appear at the bottom of your numeric columns. You can further cus...". 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 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 Users in Power BI, How to Add Visual in Power BI and How to Add Year Filters to Power BI. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
