Handling null and blank values in Power BI - Step-by-Step Guide

Introduction

Sometimes your data has empty or missing values that can cause errors or confusing results. Handling null and blank values helps you clean your data and make your reports accurate and easy to understand.

When your sales data has missing customer names and you want to show 'Unknown' instead.

When you want to count only rows that have actual values, ignoring blanks.

When you create a chart and want to avoid gaps caused by null values.

When you want to replace blank dates with a default date for calculations.

When you want to filter out rows with empty values in a report.

Steps

Step 1: Click

- Modeling tab

The ribbon shows options to create new measures and columns

Step 2: Click

- New measure

A formula bar appears to write a DAX expression

Step 3: Type

- formula bar

You enter a DAX formula that handles nulls, for example: CleanValue = IF(ISBLANK(Table[Column]), "Unknown", Table[Column])

💡 Use ISBLANK() to check for blank or null values

Step 4: Press

- Enter key

The new measure is created and appears in the Fields pane

Step 5: Drag

- New measure to a visual

The visual updates to show the cleaned values without blanks

Before vs After

Before

A table visual shows 100 rows with some rows having blank Customer Name fields

After

The same table visual shows 100 rows with 'Unknown' replacing all blank Customer Name fields

Settings Reference

ISBLANK function

📍 DAX formula bar

Detects blank or null values in data

Default: N/A

IF function

📍 DAX formula bar

Creates conditional logic to replace blanks

Default: N/A

Replace values

📍 Transform data > Power Query Editor > Home tab > Replace Values

Fix nulls before loading data into the model

Default: N/A

Common Mistakes

Using = "" to check for blanks in DAX

Blank values are not always empty strings; ISBLANK() is the correct function

Use ISBLANK() function to detect blanks instead of comparing to empty string

Ignoring nulls in visuals causing gaps or errors

Nulls can cause charts to show gaps or incorrect totals

Replace nulls with default values or filter them out before visualizing

Summary

Handling null and blank values improves data quality and report clarity.

Use ISBLANK() in DAX to detect missing values and IF() to replace them.

Fix nulls early in Power Query or with DAX measures to avoid errors in visuals.