How to replace a NULL value in Power BI Power Query

In Power BI, handling NULL values is a common data-preparation step to get your data ready for analysis, and Power Query makes this easy using the Replace Values feature.

This option is available from both the Home menu …

… and the Transform menu in the Power Query Editor.

To replace NULLs, first select the column where the NULL values exist. Then choose Replace Values. When the dialog box appears, enter null as the value to find and replace, and specify the value you want to use instead—such as 0 for numeric columns or “Unknown” for text columns.

After confirming, Power Query automatically updates the column and records the step.

Thanks for reading!

Leave a comment