How to Remove Row Grand Total in Power BI

Working with a Power BI matrix visual and finding the automatic "Total" row at the bottom more distracting than helpful? You're not alone. Removing that row grand total is a quick formatting tweak that can instantly make your report cleaner and more focused. This tutorial will walk you through exactly how to do it, step by step.

Graphed

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.

Build Your First Agent

When and Why to Remove the Row Grand Total

Before jumping into the "how," it’s helpful to understand the "why." While grand totals are useful for seeing the big picture, there are plenty of scenarios where they get in the way or are logically unnecessary. Turning them off is often a strategic design choice.

Consider removing the grand total when:

• The Total Is Meaningless: If your matrix displays metrics like conversion rates, average order value, or other percentages, summing them up often produces a nonsensical number. In this case, the grand total can be misleading.
• You Want to Emphasize Individual Rows: The main goal of your report might be to compare performance across different categories, products, or regions. A big, bold total at the bottom can draw the eye away from these individual comparisons.
• Improving Report Aesthetics: Sometimes, it’s purely about design. A cluttered report is harder to read. Removing unnecessary elements like a grand total creates more white space and helps your audience focus on what matters.
• The Data is Self-Explanatory Without a Sum: If you're showing a complete, non-sampled list of items (like all departments in a company), the audience knows they are looking at the whole picture. The grand total doesn't add new information.

Ultimately, removing the grand total helps you guide your user's attention, making your report more impactful and less confusing.

Step-by-Step Guide: How to Remove the Row Grand Total

Turning off the grand total row in a Power BI matrix visual takes just a few clicks. The setting is located in the visual formatting pane. Let's walk through it.

Step 1: Select Your Matrix Visual

First, click on the matrix visual on your Power BI report canvas. You must have the visual selected to see its specific formatting options. When selected, you'll see a border appear around it and the Visualizations pane will update to reflect the matrix's properties.

Pro Tip: If you don't see the format options described in the next steps, it's almost always because the visual isn't selected. Just click on it!

AI Agents for Marketing

Crash Course

Graphed

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.

Download the PDF

Step 2: Open the Format Pane

With your matrix selected, look to the Visualizations pane on the right side of the screen. Click on the icon that looks like a small paintbrush – this is the Format your visual icon. This is where you can control every aspect of your visual's appearance, from colors and fonts to layout and labels.

Step 3: Locate the "Row grand total" Card

Once you're in the Format pane, you'll see a list of formatting cards like "Visual," "General," "Column headers," and so on. Scroll down until you find the card specifically named Row grand total. Expand this card by clicking on its title or the small arrow next to it.

Step 4: Toggle Off the Grand Total

Inside the Row grand total card, the very first option is a simple toggle switch. By default, it will be turned On. To remove the grand total row from your matrix, simply click this toggle to switch it to Off.

As soon as you do this, you will see the "Total" row instantly disappear from your matrix on the report canvas. That's it! Your matrix is now cleaner and free of the grand total.

Grand Totals vs. Subtotals: What's the Difference?

A common point of confusion for new Power BI users is the difference between grand totals and subtotals. In the Format pane, you likely saw a "Row subtotals" card right near the "Row grand total" card. They control very different things.

• Row Grand Total: This is the single total row that appears at the very bottom of the matrix. It summarizes all the values in the entire visual.
• Row Subtotals: These appear when you have a hierarchy in your rows. They provide a summary for each parent-level category.

Graphed

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.

Build Your First Agent

Example: Regions and Countries

Imagine your matrix has two fields in the "Rows" section: Region and then Country. You might see rows like this:

• Europe
• Europe Total (This is a Subtotal)
• North America
• North America Total (This is a Subtotal)

At the very bottom of the entire matrix, you'd find one last row:

• Total (This is the Grand Total)

If you want to remove the totals for "Europe Total" and "North America Total," you would go into the Row subtotals card and toggle it off. If you only want to remove that final "Total" at the very bottom, you use the Row grand total toggle as described above.

Bonus Formatting Tips for Your Totals

What if you decide you actually want to keep the grand total but want to make it look different? Power BI gives you plenty of control over this. All the options are conveniently located in that same Row grand total card in the Format pane.

Customize the Grand Total Label

You’re not stuck with the default label "Total." In the "Row grand total" card, you'll find a field for the Title. You can change the text to something more descriptive, like "Global Summary," "Company Wide Total," or "All Regions." This adds context for your audience.

Style the Grand Total Row

Make your total row stand out visually. Still under the "Row grand total" card, you can adjust the:

• Values: Change the font, text color (e.g., make it a darker gray), or make it bold or italicized.
• Background color: Give the total row a subtle background color (like a light gray or subtle gold) to visually separate it from the data rows above.
• Border: Add top or bottom borders to clearly delineate the total section.

These small adjustments can make your report look more professional and guide your viewer's eye exactly where you want it to go.

Troubleshooting Common Problems

Running into an issue? Here are a couple of common stumbling blocks and how to solve them.

AI Agents for Marketing

Crash Course

Graphed

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.

Download the PDF

"I can't find the 'Row grand total' option!"

This happens 99% of the time because the matrix visual isn't selected. Click once on your matrix in the report canvas, and the correct contextual formatting options will appear in the Visualizations pane.

"I turned off the toggle, but a total row is still showing."

This is likely the subtotal vs. grand total confusion. If you have a hierarchy in your rows, you might have turned off the grand total at the very bottom, but the subtotals for each section are still visible. Go back to the Format pane and also turn off the toggle in the Row subtotals card if you want to remove those as well.

Final Thoughts

Removing the row grand total in a Power BI matrix is a quick and simple formatting step that comes down to finding the right toggle in the "Format your visual" pane. By decluttering your visual, you can create cleaner, more focused reports that better communicate your insights.

Manually building, formatting, and tweaking every visual in reports can feel like an endless cycle. At Graphed, we streamline this entire process. We allow you to connect all your marketing and sales data sources and then create real-time, interactive dashboards just by describing what you want to see in simple language. Instead of clicking through format panes to remove a total, you could just tell our AI, "show me revenue by country without the total," and get a perfect chart in seconds. It allows your entire team to get answers from your data without ever getting stuck on the small stuff.