How to Show Total in Power BI: 1-Min Guide

How to Show Total in Power BI

Updated on:

June 5, 2026

By:

Use this interactive demo to learn how to display column totals in a Power BI table visual.

Quick summary

Showing totals in Power BI lets analysts surface aggregated row and column sums directly inside a table visual, giving stakeholders instant data context without additional calculations. You can enable this in seconds through the Visualizations pane Format section.

Steps

Select your table visual and open the Visualizations pane.
Inside the Visualizations pane, navigate to the Format section.
Locate and select the Totals option within the Format section.
Enable Totals to activate the total row and display the total in Power BI.
Your Power BI table now shows the total row successfully.

📌 Why this matters

Displaying totals in a Power BI table visual is a fundamental reporting requirement for business analysts and data teams who need to communicate aggregated metrics at a glance. Without a visible total row, stakeholders must manually sum values, increasing the risk of misinterpretation and slowing down decision-making. Enabling the Totals feature through the Visualizations Format pane takes under a minute and immediately improves the clarity and professionalism of any Power BI report. This makes it an essential skill for anyone building dashboards, financial summaries, or operational reports in Power BI.

Your product deserves an interactive demo

Start free

How to Uninstall Power BI

How to Compare Two Measures in Power BI

How to Compare Months in Power BI