Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Remove Blank Cells in Power BI

Cody Schneider••8 min read

Staring at a Power BI report plagued by empty cells is a common frustration for data analysts at every level. These blanks can disrupt your visuals, skew your calculations, and make your entire report look unprofessional. This guide will walk you through several practical methods to remove or handle these blank cells, ensuring your data is clean and your reports are accurate.

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

Why Do Blank Cells Appear in Power BI?

Before we jump into the solutions, it helps to understand why these blanks show up in the first place. Typically, they can be traced back to one of four main sources:

  • Incomplete Source Data: The most common reason. Your original data source (like an Excel sheet or a database) simply has empty cells where data was never entered. This could be a missing phone number in a customer list or an unanswered survey question.
  • Data Model Relationship Issues: In Power BI, you often connect multiple tables. If you have a record in one table (like a sales transaction) that doesn't have a matching record in another table (like a customer dimension table), Power BI will show blanks for any fields from that unmatched dimension.
  • DAX Measure Calculations: Sometimes, the blanks aren't in your source data but are the result of a DAX calculation. A classic example is dividing by zero. If a measure calculates Sales / Transactions and a Transactions count is zero, the result will be a blank, not an error.
  • Data Structure Mismatches: When combining or appending tables, if a column exists in one table but not another, the resulting merged table will show blanks for the rows from the table that lacked that original column.

Understanding the source of your blanks helps you choose the right method to fix them. Cleaning up a messy CSV file requires a different approach than fixing a DAX measure.

Method 1: The Quick Fix Using the Filters Pane

For a fast, visual-specific solution, the Filters pane in Power BI Desktop is your best friend. This method doesn't change your underlying data, it simply hides the blank values on a specific chart, table, or an entire report page.

This is ideal when you need a quick result and don't want to get into the data transformation process.

Step-by-Step Instructions:

  1. Select the visual (e.g., a bar chart or table) that shows the blank values you want to remove.
  2. Look for the Filters pane, typically located to the right of your report canvas.
  3. Find the data field that contains the blank values. It might already be in the "Filters on this visual" section. If not, drag and drop it from the Data pane into that section.
  4. Expand the filter card for that field. You'll see a list of all values present in that column.
  5. Under "Filter type," ensure "Basic filtering" is selected.
  6. You'll see a list with checkboxes next to each value. Click (Select all) and then uncheck the box next to (Blank).

That’s it! The blank values will immediately disappear from that specific visual. You can apply this same logic to the "Filters on this page" or "Filters on all pages" sections for broader effects.

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.

When to use this method:

Perfect for a one-off chart or when you can't (or don't want to) edit the source data. Limitation: It’s a cosmetic fix. The blank data is still in your model, and you'll need to apply this filter to every new visual where you don't want to see blanks.

Method 2: The Permanent Fix in Power Query Editor

For a more permanent and robust solution, you should clean the data before it even hits your report canvas. The best place to do this is in the Power Query Editor. Changes made here are applied every time your data refreshes, ensuring consistently clean data.

Power Query is the data transformation engine built into Power BI. Think of it as your digital data laundromat - it's where you scrub, reshape, and prepare your data for analysis.

Step-by-Step: Firing Up Power Query

  1. From the Home ribbon in Power BI Desktop, click on Transform data. This will open the Power Query Editor in a new window.
  2. In the Queries pane on the left, select the query (your data table) that contains the blank cells.

From here, you have two primary options: removing the entire row where a blank exists or just replacing the blank value with something else.

Option A: Remove Entire Rows That Contain Blanks

This is useful when a row is essentially useless if a key piece of information is missing (e.g., a sales record with a blank product ID).

  1. In the Power Query Editor, find and select the column that has the blank values you want to target.
  2. Click the filter dropdown arrow at the top of the column header.
  3. In the filter list that appears, simply uncheck the boxes for null and/or (blank). Click OK.

Power Query will automatically generate a "Filtered Rows" step and remove all rows where that specific column was empty. Keep in mind that null is a true empty database value, while a blank you see might be an empty text string (""). So it's good practice to check for both.

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

Option B: Replace Blank Values with Something Else

Sometimes you don't want to lose the entire row of data - you just want to fill in the blank. For example, replacing a blank sales quantity with a zero, or a blank product description with "N/A."

  1. In the Power Query Editor, right-click on the header of the column containing the blanks.
  2. Select Replace Values from the context menu.
  3. In the dialogue box that appears:
  4. Tip: You might need to repeat this step to also replace empty text strings. In the "Value To Find" box, leave it completely empty to find and replace those.

After you’re done making changes in Power Query, click Close & Apply in the top-left corner to save your changes and load them into your Power BI model.

When to use this method:

Best practice for data hygiene. It solves the problem at the source, so you don't have to fiddle with filters on individual visuals. Limitation: Be careful when removing rows - you could unintentionally filter out important information if another column in that same row had valuable data.

Method 3: The DAX Approach for Measures

What if your data is clean, but your calculations (measures) are producing blanks? As mentioned, a common example is dividing by zero. In these cases, you can build logic directly into your DAX formulas to handle potential blanks gracefully.

Let's say you have a measure to calculate "Average Revenue per User":

Avg Revenue per User = SUM(Sales[Revenue]) / DISTINCTCOUNT(Sales[UserID])

If a product had zero users in a given month, DISTINCTCOUNT(Sales[UserID]) would be 0, and the measure would return a blank. To fix this, you can use the IF function or the safer DIVIDE function.

Using the DIVIDE Function

The DIVIDE function is designed for exactly this scenario. It takes a numerator, a denominator, and an optional third argument for the result to return if the denominator is zero.

Your improved measure would look like this:

Avg Revenue per User = DIVIDE(SUM(Sales[Revenue]), DISTINCTCOUNT(Sales[UserID]), 0)

Now, instead of a blank, the measure will return a 0 whenever the User ID count is zero, which is much better for visuals like line charts and KPIs.

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.

The "+ 0" Trick for Visuals

Sometimes you simply want your visual to display a 0 instead of a blank. A quick and easy way to force a DAX measure to show a zero is to literally add zero to the end of your expression.

Total Sales Display = [Total Sales Measure] + 0

When you add zero to a blank value in DAX, it converts the blank to a zero. This simple trick can solve formatting issues in tables and matrices where blanks are causing visual gaps.

When to use DAX:

When the blanks are not from your source data but are the result of mathematical operations in your measures.

Final Thoughts

Handling blanks is a fundamental part of building reliable and clean Power BI reports. Whether you need a quick visual fix with the Filters pane, a robust data cleaning process in Power Query, or a calculated solution with DAX, you now have the tools to tackle any empty cell that comes your way.

While Power BI is incredibly powerful, mastering its different interfaces - from Power Query to DAX - takes time and a lot of clicks. Setting up data connections, cleaning tables, and building measures is often a manual process that can slow you down. At Graphed, we built a tool to eliminate that friction completely. Instead of building reports manually, you can connect your data sources in seconds and use simple, natural language to create dashboards and get answers, letting you focus on the insights, not just the setup.

Related Articles