How to Hide Rows in Power BI

Hiding certain rows is a fundamental step in building clean and focused Power BI reports. Whether you're trying to remove blank values, filter out irrelevant data, or simply tidy up a visual, knowing how to selectively hide rows is essential for clear data storytelling. This guide will walk you through several effective methods, from simple filters to more powerful DAX expressions, so you can choose the best approach for any situation.

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 Need to Hide Rows in Power BI?

Before diving into the "how," it helps to understand the "why." You're not deleting data from your original source, you're just controlling what's visible within your report to make it more impactful. Slicing away unnecessary information helps your audience focus on the insights that matter most.

Here are a few common scenarios where hiding rows is necessary:

• Removing Blanks or Zeros: Your dataset might include products that had no sales in a given month or leads with no activity. Displaying these rows of zeros or blanks can clutter a table and distract from the actual performers.
• Filtering Out Test Data: Developers and admins often use test accounts or placeholder entries (like names "test user" or email addresses from "test.com"). These rows are crucial for system maintenance but irrelevant for business analysis.
• Excluding Incomplete Records: You might have rows where key information is missing, such as a customer record without an assigned country. Including these can skew calculations and create a misleading "(Blank)" category in your charts.
• Focusing on Specific Segments: A report page might be dedicated to analyzing your top 10 products or a specific region. Hiding all other rows is essential to creating this focused view.
• Hiding Outliers: Sometimes an extreme data point, like a one-time bulk order, can distort the scale of your charts. While you might not want a permanent removal, you may want to hide it in certain visuals to better see the typical performance trends.

Method 1: Using the Filters Pane (The Easiest Approach)

The most straightforward way to hide rows for a specific chart or page is by using the built-in Filters pane. This method doesn’t permanently alter your dataset, it simply applies a temporary rule to a visual, a page, or the entire report to control what's shown to the end-user.

This is the perfect method for quick, interactive adjustments and is incredibly user-friendly.

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 the table, matrix, or chart you want to modify. You'll see its border highlighted.
2. Open the Filters Pane: This pane is usually visible on the right side of the Power BI Desktop canvas. If you don’t see it, go to the "View" tab on the ribbon and make sure "Filters" is checked.
3. Choose Your Filter Level: The Filters pane has three levels:
4. Add the Data Field to Filter: From the "Fields" pane, find the column that contains the values you want to use as a filter condition. Drag and drop this field into the appropriate section of the Filters pane (e.g., "Filters on this visual").
5. Set Your Filter Condition: You now have several options:

Let's say you have a table of product sales, and many products have no sales (blank values). To hide them, you would drag the "Sales Amount" field to the "Filters on this visual" bucket, select "Advanced filtering," set the rule to "is not blank," and click "Apply filter." Instantly, your table will update to show only products with actual sales data.

Method 2: Using the Power Query Editor (For Permanent Data Cleaning)

If you know certain rows should never appear in your report, it's best to remove them at the source by using the Power Query Editor. Changes made here affect the entire dataset before it even loads into your Power BI data model. This means the hidden rows won't be available for any calculations or visuals anywhere in your report – making for a cleaner, faster, and more efficient model.

Use this method when you want to permanently clean your data, for example, by removing all test entries, headless orders, or records from a decommissioned system.

Step-by-Step Instructions:

1. Launch Power Query Editor: On the "Home" tab in Power BI Desktop, click the "Transform data" button. This will open a new window, which is the Power Query Editor.
2. Select the Correct Query: On the left side, you’ll see a list of all your queries (which correspond to your data tables). Click on the one you want to modify.
3. Use the Column Filter: Find the column that contains the criteria for the rows you want to hide. Just like in Excel, each column header has a dropdown arrow. Click it to reveal sorting and filtering options.
4. Remove the unwanted values: A list of all unique values in that column will appear. Simply uncheck the box next to any value you want to hide. For example, you could uncheck (blank) or null to remove rows with missing information in that column, or uncheck "Internal Use" from a Lead Source column.
5. Close and Apply: Once you're done, click the "Close & Apply" button in the top-left corner. Power Query will process your changes and refresh your data model in Power BI Desktop. The rows you filtered out will now be gone from your entire report.

The beauty of Power Query is the "Applied Steps" pane on the right. Every transformation you make, including filtering rows, is recorded as a step. If you ever make a mistake, you can simply click the 'X' next to the "Filtered Rows" step to undo it, giving you total control over your data cleaning process.

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

Method 3: Using DAX (For Dynamic & Conditional Hiding)

For the ultimate flexibility, you can use Data Analysis Expressions (DAX) to hide rows based on complex calculations or dynamic conditions. This approach doesn't filter the data itself but works by creating a measure that returns a blank value for the rows you want to hide. Power BI visuals, by default, do not display rows where the measure value is blank.

This is the best method when the decision to hide a row depends on a calculated outcome, like hiding products with less than $50 in profit or salespeople who haven't met a certain KPI.

Scenario: Hiding Rows with Zero or Blank Sales Totals

Imagine a table showing Product Name and Total Sales. If you slice the data by a specific month, many products might show up with a blank sales value. Using a DAX measure makes your table cleanly adapt to show only products that actually sold during that month.

Step-by-step instructions:

1. Create a Base Measure: First, ensure you have a base measure for your calculation, like total sales. If you don't, create one by right-clicking your table in the "Fields" pane and selecting "New measure."

Total Sales = SUM('Sales'[Sales Amount])

1. Create the Hiding Measure: Now, create a second measure that will control the visibility. This measure checks the result of your base measure and returns BLANK() if the condition for hiding is met.

Sales To Display = 
IF(
    [Total Sales] > 0, 
    [Total Sales], 
    BLANK()
)

This formula says: "If the Total Sales is greater than zero, show the Total Sales. Otherwise, return a blank value."

1. Use the New Measure in Your Visual: Instead of using the original Sales Amount column or your basic [Total Sales] measure in your table, use your new [Sales To Display] measure. When you do, Power BI will automatically evaluate each row. For any product where [Sales To Display] returns BLANK(), that entire row will be hidden from the table.

This DAX technique is extremely powerful because it's dynamic. If a user selects a different date range with a slicer, the measure re-evaluates, and the table automatically updates to show only the relevant products for the new period. You don't need to manually adjust any filters.

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

Choosing the Right Method for Your Goal

Not sure which route to take? Here’s a quick guide to help you decide:

• Use the Filters Pane when: You need a quick, simple way to clean up a specific visual or page. The logic for hiding is straightforward (e.g., unchecking a category or excluding blanks). This is best for interactive reporting and user-facing dashboards.
• Use the Power Query Editor when: You know for sure that certain data should be completely excluded from your entire report. This is a foundational data modeling step for removing junk data and improving model performance.
• Use DAX when: The criteria for hiding are conditional and based on a calculation (like measure > X). This provides the most dynamic and flexible solution, allowing your visuals to automatically adapt as users interact with slicers and other filters.

Final Thoughts

Hiding rows in Power BI is a core skill for cleaning up your visuals and directing focus toward meaningful data. By mastering the Filters pane for quick fixes, Power Query for permanent data prep, and DAX for dynamic control, you have a complete toolkit to build reports that are both clean and compelling.

Ultimately, the goal is to make data easier to understand without getting bogged down in technical complexities. At Graphed, we've extended this principle by creating a platform where you don’t need to be a BI expert to get answers. We allow you to connect all your marketing and sales data sources in just a few clicks. From there, you can build dashboards and reports by simply describing what you want in plain English, and our AI handles the complex steps like filtering out irrelevant data for you. So instead of searching for how to hide a row, you can get straight to the insights. To explore a faster way to analyze your data, check out Graphed and see how it works.