How to Remove Null Values in Power BI

Dealing with null values in your data can feel like hitting a series of unexpected potholes on an otherwise smooth road. These empty cells can break your charts, skew your calculations, and lead to misleading reports. The good news is that Power BI provides several straightforward ways to clean them up. This guide will walk you through the most common and effective methods for removing and handling null values, so you can get back to building reports you can trust.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Null Values Are a Problem in Your Reports

Before jumping into the "how," it's helpful to understand why null values are so disruptive. They aren't just empty spaces, they represent the absence of data, and Power BI treats this absence in ways that can negatively impact your analysis.

• Skewed Calculations: When you perform calculations like an 'Average,' Power BI ignores nulls. If you have a column of sales figures and a few are null, the average will be calculated only from the sales that have a value, potentially making your average performance look better or worse than it actually is. Sums work, but counts and averages can be misleading.
• Broken Visuals: Think of a line chart showing daily revenue. If a day has a null value, you might see a sudden, sharp drop to zero or a complete gap in your line, making it difficult to visualize trends accurately. Bar charts might omit categories entirely.
• Misleading Interpretations: An empty value in a 'Customer feedback score' column doesn't mean the score is zero, it often means no feedback was given. Treating it as a zero would completely distort your customer satisfaction metrics. Cleaning these nulls ensures you're telling the right story with your data.

Cleaning this up happens in the Power Query Editor, the data transformation engine built into Power BI. To get there, simply click the ‘Transform Data’ button on the Home ribbon of Power BI Desktop.

Method 1: Remove Entirely Empty Rows

This is the most direct approach. If a row contains null values in key columns and provides no useful information, you can remove the entire row. This is common when you have rows where, for example, a sale was started but never completed, leaving columns like Revenue, Product_ID, and Customer_Name blank.

Use this method when the absence of a value in a specific column makes the entire row irrelevant to your analysis.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step Guide:

1. From the Power BI Desktop main window, click ‘Transform Data’ on the Home tab to open the Power Query Editor.
2. In the Power Query Editor, select the column that contains the null values you want to target.
3. Go to the ‘Home’ tab in the ribbon at the top.
4. Click on the ‘Remove Rows’ dropdown menu.
5. From the dropdown, select ‘Remove Blank Rows’. Power Query will scan the entire table and remove any row that is completely empty.

Note: If you want to remove rows that are null just in one specific column (not the whole row), select that column, click the dropdown arrow filter icon in the column header, uncheck (null), and click ‘OK’. This is a filtering approach, covered next.

Method 2: Directly Filter Out Nulls

Filtering is one of the easiest and most common ways to hide rows with null values without permanently deleting them in the query itself. It works just like a filter in Excel and is incredibly intuitive.

This method is perfect when you want to look at a dataset of only 'complete' records, for instance, analyzing sales performance only for transactions that have an associated Revenue figure.

Step-by-Step Guide:

1. With your data loaded in the Power Query Editor, find the column where you want to remove the null values.
2. Click on the dropdown arrow located in the header of that column. This will open the filter and sort menu.
3. You'll see a list of all the unique values in that column, including an option for (null). By default, all values are checked.
4. Simply uncheck the box next to (null).
5. Click ‘OK’. Power Query will immediately hide all rows where that specific column had a null value.

The step is recorded in your ‘Applied Steps’ pane on the right, so you can easily undo it later if you need to.

Method 3: Replace Null Values with Something Else

Sometimes, removing an entire row isn't the right move. The row might contain lots of other useful data. A null in a Discount_Amount column doesn't mean the sale is invalid, it just means no discount was applied. In cases like this, replacing the null value is a much better choice.

You can replace nulls with a zero, descriptive text like "N/A," or any other value that makes sense in your context.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step Guide:

1. In the Power Query Editor, select the column with the null values you want to replace. You can select multiple columns by holding down the 'Ctrl' key while clicking on the headers.
2. Navigate to the ‘Transform’ tab in the ribbon.
3. In the 'Any Column' group, click on the ‘Replace Values’ button. (This button is also available on the Home tab).
4. A dialog box will appear. In the ‘Value To Find’ field, type the word null. It's important to use the lowercase null, without quotes.
5. In the ‘Replace With’ field, enter the value you want to use instead. For a numerical column, this is often 0. For a text column, it might be "Not Provided" or "N/A".
6. Click ‘OK’. Power Query will find every null value in your selected columns and swap it with the replacement value you specified.

Method 4: Handle Nulls with DAX Measures

Sometimes, you might want to keep your underlying data exactly as it is (nulls and all) but handle the nulls within specific calculations. This gives you more flexibility at the report level. This is done using DAX (Data Analysis Expressions), Power BI's formula language.

This approach is best when the "correct" way to handle a null depends on the specific chart or KPI you're building.

Using IF and ISBLANK

A classic DAX pattern is to check if a value is blank and return an alternative if it is. Let's say you want to create a measure for total revenue but want to treat any null revenue entries as 0.

You could create a new measure like this:

Revenue With Zeros =
SUMX(
    'YourTableName',
    IF( ISBLANK('YourTableName'[Revenue]), 0, 'YourTableName'[Revenue] )
)

This formula iterates through your table. For each row, it checks if the [Revenue] column is blank. If it is, it uses 0, otherwise, it uses the existing revenue value. Then it sums up the result.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Using COALESCE for a Cleaner Solution

The COALESCE function is an even simpler way to do this. It returns the first non-blank value it finds in a list of arguments. You can use it to replace blanks with a default value on the fly.

Here’s the same goal achieved with COALESCE:

Total Revenue (Handled Nulls) = 
SUMX(
    YOUR_TABLE_NAME, 
    COALESCE([sales_paid], 0)
) 

This does the same thing as the IF(ISBLANK()) version but is much shorter and easier to read. For each row, COALESCE looks at the [sales_paid] value. If it's not blank, it returns that value. If it is blank, it moves to the next argument, which is 0, and returns that instead. Then SUMX adds it all up.

Which Method Is Right for You?

Deciding which strategy to use often comes down to your analytical goal.

• Remove Rows (or Filter): Use this when a row is fundamentally incomplete and including it would harm your analysis. For example, a customer record with no contact information or name is essentially useless.
• Replace Values: Use this when a null has an implicit business meaning. A null in a Commission column likely means zero commission and should be replaced with 0 so it can be included in calculations correctly. A null SurveyResponse could be replaced with "No Response".
• Handle with DAX: Use this when you prefer to preserve your source data in its raw state but need flexibility for different charts and reports. This keeps your data cleaning logic at the "presentation" layer, making it transparent and easy to change for individual visuals without altering the base query.

Final Thoughts

Successfully cleaning null values in Power BI is a critical step towards accurate and reliable reporting. By using Power Query’s intuitive tools like 'Remove Rows', 'Replace Values', and filters, or by applying DAX functions like IF/ISBLANK and COALESCE at the measures level, you have full control over how to handle missing data to fit your specific needs.

Of course, this process of cleaning and preparing data - whether in Power BI, Excel, or Google Sheets - is often the most time-consuming part of analytics. We built Graphed because we believe getting insights shouldn't require so many manual steps. Instead of wrestling with data cleaning steps for every source, you can connect platforms like Google Analytics, Shopify, and your CRM in a few clicks. Then, just use plain English to ask what you want to see, and Graphed builds a live, interactive dashboard for you, handling all the complex data heavy lifting behind the scenes.