How to Remove Total Column in Power BI

Struggling with that automatic "Total" column Power BI adds to your tables and matrices? While it's often helpful, sometimes it just clutters your visual or presents a nonsensical sum. This article walks you through several straightforward methods to remove the total column, from a simple toggle switch to a flexible DAX formula for more complex scenarios.

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

Why Would You Want to Remove the Total Column?

Power BI is designed to aggregate data, and totals are a big part of that. However, there are many valid reasons you might want to hide or completely remove them. Understanding your "why" will help you choose the best method.

• Visual Clarity: The grand total column can sometimes distract from the main data points you want to highlight. Removing it can create a cleaner, less cluttered, and more focused report page.
• Irrelevant Aggregations: Totals aren't always meaningful. For instance, if your table shows an average percentage like Average Order Value (AOV) or a Customer Satisfaction Score (CSAT) by region, a grand total of those averages is usually mathematically incorrect and misleading. You can't just sum or average the averages.
• Focusing on Details: In some reports, the focus is purely on the performance of individual categories, products, or sales reps. The total might be an unnecessary piece of information that takes up valuable space.
• Custom Calculations: You may need to replace Power BI's default total with your own custom total calculated with a specific DAX formula. In this case, the first step is to get rid of the automatic one.
• Layout and Formatting: Sometimes, the total column just doesn’t fit your report’s design aesthetic. Leaving it out gives you more control over the final look and feel of your visuals.

Method 1: The Quickest Fix - Using the Format Pane

For most simple cases, all you need is a couple of clicks in the "Format your visual" pane. This method works for both Table and Matrix visuals and is the first thing you should try.

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-by-Step Instructions

Let's walk through the process, assuming you have a Matrix visual with product categories and total sales.

1. Select Your Visual: Click on the table or matrix on your report canvas. You should see a highlighted border around it, and the Power BI panes on the right (Data, Format, etc.) will now relate to this visual.
2. Open the Format Pane: On the right side of the Power BI window, click on the paintbrush icon labeled "Format your visual." This is where you control everything related to the appearance of your chart.
3. Find the "Totals" Section: In the list of formatting options, find and expand the "Totals" section. You might need to scroll down a bit. Here, you'll see a few toggle switches that control both column and row totals.
4. Turn Off Column Grand Totals: You'll see an option labeled "Column grand total" or simply "Totals" with toggles for values. To remove the final total column at the very right, just click the toggle to turn it Off.

As soon as you toggle it off, the grand total column will vanish from your visual. It's really that simple! You can turn it back on just as easily if you change your mind.

Pro Tip: If you're a heavy matrix user, you'll find more granular control here to toggle subtotals and customize their position (top or bottom). Play around with these settings to see how they affect your visual's layout.

Method 2: The Precise Approach - Using DAX to Hide Specific Totals

What if you want totals for some columns but not for others? The formatting pane is an all-or-nothing solution, it removes the total for every measure in your visual. For precise control, you need to use a simple DAX formula.

The magic ingredient here is the HASONEVALUE() or ISINSCOPE() function. These functions can detect whether the calculation is happening on a regular row or within a grand total row.

How It Works

The basic logic is this: you create a new measure that says, "IF you're looking at a single category/product/region, then calculate the sum. IF you're looking at the total row (where you're not looking at just one thing), show a blank instead."

Blanks are great because Power BI doesn't display them in visuals, effectively hiding the result in the total row.

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

Step-by-Step DAX Example

Imagine your matrix shows sales revenue and an average discount percentage by product category. You want the total for sales revenue but hiding the total for the discount percentage is crucial because averaging the averages is bad practice.

1. Create a New Measure: Right-click on your data table in the Data pane and select "New measure." The formula bar at the top of the screen will open up.
2. Write the DAX Formula: Let's say your original measure was Average Discount = AVERAGE('Sales'[Discount %]). Your new measure would look like this:

Avg Discount No Total = 
IF(
    HASONEVALUE('Products'[Category]),
    AVERAGE('Sales'[Discount %]),
    BLANK()
)

1. Breakdown of the Formula:

• IF(...): This is a standard conditional check.
• HASONEVALUE('Products'[Category]): This returns TRUE if the context is filtered down to a single product category. It returns FALSE for the "Total" row, because that row includes all categories.
• AVERAGE('Sales'[Discount %]): Your original calculation, which runs if the condition is TRUE.
• BLANK(): The measure returns nothing if the condition is FALSE, hiding the total.

1. Use the New Measure in Your Visual: Drag your new measure, Avg Discount No Total, into your visual. Then, remove the old Average Discount measure.

Now, your matrix will show the sales revenue total as usual, but the total for the average discount will be empty, making your report more accurate and professional.

Method 3: The Visual Trick - Conditional Formatting

This method is a bit of a "hack," but it's a clever way to visually hide a total without writing complex measures. Essentially, you use conditional formatting to change the font color of the total value to match your visual's background color, making it invisible.

This is useful if you can't alter the data model but still need to hide a total for presentation purposes.

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-by-Step Instructions

1. Select Your Visual: Click on your table or matrix.
2. Navigate to Cell Elements: Go to the "Format your visual" pane and find the "Cell elements" section.
3. Choose Your Field: In the "Apply settings to" dropdown, select the column whose total you want to hide.
4. Turn On Font Color: Find the "Font color" toggle and switch it on. The fx (conditional formatting) icon next to it will become active. Click it.

Set Up the Formatting Rule

1. Format Style: In the new window, select "Rules" for the format style.
2. Field to Base the Rule On: The key is to create a rule based on what identifies the total row. A simple trick is to set the rule based on the count of your categories.
3. Create the Rule: Now, set up the rule like this: "If value is greater than 1 then [choose your background color]."
4. Apply the Formatting: Choose a font color that matches your total row's background color (usually white or a light gray). Click "OK."

The total number will still be there technically, but it will be completely camouflaged. Be careful with this method — if you export the data to Excel, the value will reappear!

Final Thoughts

Knowing how to control totals in Power BI is a fundamental skill that elevates your reports from basic to professional. Whether it's a quick toggle in the format pane, a precise DAX measure using HASONEVALUE, or a clever formatting trick, you now have the tools to make your visuals display exactly what you intend, improving clarity and accuracy.

While mastering tools like Power BI is incredibly powerful, we know that many marketing and sales teams need answers without the steep learning curve. If you find yourself spending more time wrestling with formatting panes and DAX than acting on insights, you might appreciate how we've simplified the entire process. With Graphed, you connect your data sources in a few clicks and build reports just by asking questions in plain English. No toggles to find or code to write — just fast, clear answers from your data so you can get back to growing your business.