Replace values in Power BI - Step-by-Step Guide

Introduction

Replacing values lets you fix or clean data by changing specific entries. This helps when you have typos, wrong labels, or need to standardize data before analysis.

When your sales data has misspelled product names that need correction

When you want to change all 'N/A' entries to blank or zero for calculations

When you need to replace old region codes with new ones in your dataset

When you want to standardize different date formats into one consistent format

When you want to fix inconsistent capitalization in customer names

Steps

Step 1: Open

- Power Query Editor

The data preview window shows your table with columns and rows

Step 2: Select

- the column where you want to replace values

The column is highlighted for editing

Step 3: Click

- Home tab > Replace Values button

A Replace Values dialog box appears

Step 4: Type

- 'Value To Find' field in the dialog

The value you want to replace is entered

Step 5: Type

- 'Replace With' field in the dialog

The new value to replace with is entered

Step 6: Click

- OK button in the Replace Values dialog

All matching values in the selected column change to the new value

Step 7: Click

- Close & Apply button in Power Query Editor

The changes are saved and applied to your Power BI report

Before vs After

Before

Column 'Region' has values: 'North', 'Noth', 'South', 'East', 'West'

After

Column 'Region' has values: 'North', 'North', 'South', 'East', 'West'

Settings Reference

Value To Find

📍 Replace Values dialog box

Specifies the exact value in the column to be replaced

Default: Empty

Replace With

📍 Replace Values dialog box

Specifies the new value that will replace the old one

Default: Empty

Match entire cell contents

📍 Replace Values dialog box (checkbox)

If checked, only cells exactly matching the value are replaced; if unchecked, partial matches are replaced

Default: Unchecked

Common Mistakes

Replacing values without selecting the correct column

The replacement happens in the wrong column, causing unexpected data changes

Always select the specific column where you want to replace values before using Replace Values

Not matching the exact value due to case sensitivity or extra spaces

Values that look similar but differ in case or spaces won't be replaced

Check for exact spelling, case, and spaces in the 'Value To Find' field or clean data first

Summary

Replace Values lets you fix or standardize data entries in a selected column.

You must select the correct column before replacing values to avoid errors.

Use the 'Match entire cell contents' option to control exact or partial matching.