Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Remove Totals in Power BI

Cody Schneider••8 min read

Here's the converted Markdown version of the provided HTML content:

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

You've carefully built the perfect matrix or table in Power BI, connected your data, and arranged your fields. But there’s one small thing throwing off your entire report: those automatic, and often unnecessary, "Total" and "Subtotal" rows. They can be distracting, misleading, or simply take up valuable dashboard space. This article will show you exactly how to remove totals and subtotals in Power BI, giving you full control over how your data is presented.

Why Would You Want to Remove Totals in Power BI?

While totals are useful for summarizing straightforward data like revenue or units sold, they can sometimes cause more harm than good. Getting rid of them isn't just about making your report look cleaner, there are solid analytical reasons why you might want to turn them off.

  • Improved Clarity and Focus: Sometimes, the main story is in the details, not the sum. Removing a large, bold "Total" row helps guide your audience's eyes to the individual rows and columns that matter most, preventing them from being distracted by a summary figure.
  • Dealing with Non-Additive Metrics: This is a big one. If your visual shows percentages, averages, ratios, or prices, the "Total" row often calculates something meaningless or flat-out incorrect. For example, the sum of percentages doesn't make sense, and the "average of the averages" is rarely a useful metric. Removing the total prevents this misleading aggregation.
  • Custom Calculations: You may have created your own sophisticated DAX measure to act as a total. In this case, Power BI's default total row is redundant and can conflict with the custom calculation you’d rather display.
  • Dashboard Layout and Space: Real estate on a dashboard is precious. In a dense report with multiple visuals, removing extra rows and columns for totals can free up just enough space to make your dashboard feel less cramped and easier to read.

The Quickest Method: Using the Format Pane

For most day-to-day scenarios, especially with table and matrix visuals, Power BI has a simple toggle switch to turn totals and subtotals on or off. This is the first place you should look when trying to get rid of them.

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Step-by-Step Guide for Tables and Matrices

Let's walk through the process using a common visual: the matrix. The steps are nearly identical for a standard table.

Imagine you have a matrix showing Sales broken down by Product Category and then by Sub-Category.

By default, Power BI adds subtotals for each Product Category and a grand total at the bottom. Here’s how you remove them:

  1. Select Your Visual: Click on the table or matrix in your report canvas to make it active. You'll know it's selected when a border appears around it.
  2. Open the Visualizations Pane: On the right-hand side of the Power BI window, make sure the Visualizations pane is expanded. If not, click its icon to open it up.
  3. Go to "Format your visual": Within the Visualizations pane, click the icon that looks like a paintbrush. This is where you control the look and feel of your selected chart.
  4. Find the "Subtotals" Section: Scroll down the list of formatting options until you find Subtotals. Click to expand it.
  5. Turn Them Off: Here you will see toggles for Row subtotals and Column subtotals. To remove the subtotals for each product category, simply click the toggle for Row subtotals to turn it off.

That's it for the subtotals! But what about the grand total at the very bottom?

  1. Find the "Grand total" Section: In the same "Format your visual" list, find the setting for Grand total (It was previously called "Totals" in older versions of Power BI).
  2. Turn It Off: Expand the section and you will see a toggle. Click it to turn the grand total off. If you have both row and column grand totals, you can turn them off individually here.

Pro Tip: Per-Level Customization

Sometimes you don't want to remove all subtotals. You might want to show a subtotal for the main category but not for a more granular one. Power BI lets you do this:

  • In the Row subtotals settings, you'll see a switch for Per row level.
  • Turn this on, and a list of your row fields will appear (e.g., Product Category, Sub-Category).
  • You can now use individual toggles to turn subtotals off for just one specific level, giving you precise control over your visual.

Controlling Totals in Other Visuals

While tables and matrices are the most common places to want to remove totals, other chart types have their own version of a "total."

Total Labels in Stacked Charts

In a stacked column or stacked bar chart, Power BI gives you the option to add "Total labels" which display the sum of the stack on top of each bar.

To remove or add these:

  1. Select your stacked chart.
  2. Go to the Format your visual pane.
  3. Find and expand the Data labels section.
  4. At the bottom of this section, you will find a toggle for Total labels. Switch it off to hide the summary values on top of each bar.
GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

The Advanced Method: Suppressing Totals with DAX

What if the simple formatting toggles aren't enough? In some advanced scenarios, you might want more control, like showing a blank cell or custom text instead of a total. This is where Data Analysis Expressions (DAX) come in. By writing a slightly more advanced measure, you can tell Power BI not to perform the calculation in the total row.

The most common DAX functions for this are HASONEVALUE(), ISFILTERED(), or comparing a selected value against a count of all values.

Let's look at an example. Imagine you have a measure to calculate average sale price:

Average Price = AVERAGE(Sales[Price])

If you put this in a matrix with Product Categories, the "Total" row will show the average of all the category averages, which is arithmetically incorrect and misleading. We want to show a value for each category, but nothing in the total row.

You can create a new DAX measure to handle this:

Average Price (No Total) = 
IF(
    HASONEVALUE(Products[Category]),
    AVERAGE(Sales[Price]),
    BLANK()
)

Let’s break this down:

  • HASONEVALUE(Products[Category]) is a check that returns TRUE only if the calculation is happening for a single product category (i.e., in a detail row).
  • For the "Total" row, the calculation is happening across all categories, so HASONEVALUE() will return FALSE.
  • The IF statement checks this condition. If it's true (a detail row), it calculates the average price. If it's false (the total row), it returns BLANK(), which effectively hides the value from appearing in the visual.

Now, when you use this new Average Price (No Total) measure in your matrix, the product category rows will populate as expected, but the total row will be completely blank - problem solved!

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Common Pitfalls and Best Practices

  • Totals Reappear Unexpectedly: Sometimes, when you add new fields to your matrix or change the visual type, Power BI might reset some of your formatting. If your totals pop back up, just revisit the Format your visual pane to turn them off again.
  • It's Just a Visual Change: Remember that hiding totals in the formatting pane only changes the display of a specific visual. Your underlying DAX measures will still calculate totals in the background. Use the DAX method if you need to fundamentally change the calculation logic itself.
  • Save Time with a Template: If you find yourself constantly removing totals from every matrix, consider creating a PBIX file with a pre-formatted, totals-free visual. You can use this as your starting template for new reports to save yourself a few clicks every time.

Final Thoughts

Controlling the display of totals and subtotals is a fundamental part of designing clean, effective reports in Power BI. Whether you use the simple toggles in the formatting pane for quick adjustments or a calculated DAX measure for more complex scenarios, you now have the tools to ensure your visuals only show what you want them to, making your data stories clearer and more impactful.

While mastering these tweaks in Power BI is a valuable skill, we believe getting clear answers from your data shouldn't always require hunting through formatting panes and writing custom code. That's why we built Graphed. We connect directly to your favorite data sources, and you can create charts and dashboards just by asking in plain English. Instead of trying to find the right 'Subtotals' toggle, you can just tell our AI, "Show me a table of sales by product category and subcategory," and get a clean visual instantly, without any unneeded clutter.

Related Articles