How to Turn Off Grand Total in Power BI Matrix

The matrix visual in Power BI often adds a Grand Total row or column by default, which can be useful for summarizing your data at a glance. But sometimes, that total isn't necessary, takes up valuable space on your dashboard, or even misrepresents the data you're trying to show. This tutorial will walk you through the simple steps to turn off the Grand Total for both rows and columns in your Power BI matrix.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Remove the Grand Total in a Power BI Matrix?

Ditching the Grand Total isn't just about making your reports look cleaner, it often serves a strategic purpose. Having control over this feature allows you to guide your audience's focus and ensure your data tells the right story.

Here are a few common scenarios where removing the Grand Total makes sense:

• Avoiding Misleading Calculations: If your matrix contains values that shouldn't be added together, such as averages, percentages, or distinct counts, the Grand Total can be deceptive. For example, summing up the "Average Order Value" for three different regions doesn't give you the total average order value for the company. Hiding the total prevents this misinterpretation.
• Improving Dashboard Clarity: On a crowded dashboard, every pixel matters. Removing a non-essential total row or column can free up space and reduce visual clutter, allowing more important metrics or visuals to stand out. It helps create a more focused and less overwhelming user experience.
• Focusing on Individual Components: Your goal might be to highlight the performance of individual categories, regions, or salespeople. In these cases, the Grand Total can be a distraction, drawing the eye away from the detailed line items you want your audience to analyze. By removing it, you direct attention to the comparison between these components.
• Custom Reporting Needs: Some financial reports or operational summaries have strict formatting requirements and don't include grand totals. To replicate an existing report format that stakeholders are accustomed to, you'll need the flexibility to toggle totals on and off.

Ultimately, choosing to show or hide the Grand Total is a design decision that impacts how your data is perceived. Knowing how to control it is fundamental to building effective and professional reports.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

A Quick Look at the Matrix Visual

Before jumping into the steps, let's quickly review the components of a Power BI matrix. Think of it as a super-powered pivot table directly within your report. It allows you to display data in a grid format with a hierarchical structure.

The key configuration areas in the 'Build a visual' pane are:

• Rows: This is where you drag the fields you want to use for the row headers. You can add multiple fields to create a hierarchy (e.g., Region > Country > City).
• Columns: This is for your column headers. Like rows, you can add multiple fields to create nested columns (e.g., Year > Quarter).
• Values: This field accepts the numeric data you want to display in the matrix, such as Sales, Revenue, or Quantity.

When you place fields in both the 'Rows' and 'Columns' sections, Power BI automatically calculates and displays subtotals for each level of the hierarchy and a Grand Total for both the rows and columns. It’s this automatic Grand Total feature that we’re going to customize.

Step-by-Step: How to Turn Off Grand Totals in a Matrix

Disabling grand totals is managed in the Format visual pane. The process is straightforward and gives you individual control over row and column totals. Let’s get started.

For this example, let's assume you have a matrix showing Total Sales (in Values) categorized by Region (in Rows) and by Year (in Columns), and you want to remove the grand totals for both.

1. Select Your Matrix Visual

First, click on the matrix visual on your report canvas to select it. You'll know it's selected when a border appears around it and the accompanying configuration panes (like Format visual) become available on the right-hand side of the Power BI window.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

2. Open the Format Visual Pane

With the matrix selected, look for the vertical list of panes to the right of your report. Click the icon that looks like a paintbrush and a bar chart, which is the Format visual pane. This is where you control all the aesthetic and formatting aspects of your visual.

3. Locate the "Subtotals" Card

In the Format visual pane, you’ll see a list of formatting categories (e.g., Column Headers, Values, Grid). Scroll down this list until you find the card named Subtotals.

Hot Tip: If Power BI’s user interface ever changes with an update and you can't find these options, you can use the search bar at the top of the Format panel. Simply type "total" to quickly filter for the relevant settings.

Power BI groups the "Subtotals" and "Grand Total" under a single card. As of the latest updates, you'll find these settings under the Subtotals card. In previous versions, they might have been in separate cards.

3a. Turn Off the Row Grand Total

Within the Subtotals card, you'll find separate sections for Row subtotals and Column subtotals. To disable the row grand total, look for a toggle switch labeled Row subtotals and turn it off. This will immediately remove the bottom Grand Total for the rows in your matrix.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

3b. Turn Off the Column Grand Total

Right below the row subtotal controls, you'll find the settings for Column subtotals. Here you’ll see a toggle to enable or disable the column totals. Turn off the Column subtotals toggle to remove the Grand Total from the right side of your matrix.

Note: You can disable the row and column totals independently to match your analysis needs.

4. Advanced Control: Customize Your Subtotals

The Subtotals card offers more than just toggling totals. Here are some additional options:

• Rename Subtotal Label: You can change the label of the total row or column. Instead of showing "Total," customize it to "Grand Total," "Summary," or "Overall."
• Configure Subtotal Position: If you have multiple levels in your Rows or Columns hierarchies (e.g., Year > Quarter), you can choose whether the subtotals appear at the top or bottom of each level.

These customization options help tailor your report to specific standards or improve clarity.

Common Issues & Troubleshooting

While the process is generally smooth, you may occasionally encounter some hurdles. Here’s how to troubleshoot:

• The Toggle is Off, but I Still See Totals: If hierarchy levels on both rows and columns are enabled, subtotals might still appear due to nested configurations. Double-check the Subtotals card to ensure both row and column settings are disabled.
• Difficulty Finding Options: Power BI updates can change interface layouts. Use the search bar in the Format visual pane—it's your best friend for quickly finding settings.
• Totals Showing Incorrect Values: Unexpected grand total numbers may be caused by measure calculations. Hiding totals can hide the issue temporarily, but reviewing your measures is advisable for a long-term fix.

Final Thoughts

Controlling the visibility of Grand Totals in a Power BI matrix is a straightforward but powerful skill that enhances report clarity and professionalism. Whether you aim for a cleaner look, prevent misleading calculations, or replicate specific report formats, mastering this feature is beneficial.

If you find yourself endlessly navigating the Format Visual pane to customize each detail, consider using platforms like Graphed to streamline your workflow. Efficient dashboard building saves time and allows you to focus on insightful analysis.