How to replace null values in Power BI

Question

How to replace null values with custom values in Power BI(power query editor)?

Answer 1

Hi Nithin,

To fill or replace the null or any values, you can follow these steps.

1. Select the column that you want to fill or replace the values

2. Then click on transform tab 

3. Now you can select replace or fill.

• If you select fill then the values in the field are either copied from up to down or vice-versa. (Preferred when the data of that column not highly important )
• If you select replace then the following dialog box opens.

       

       You can now enter null values or different values that you want to replace and the replace with values.

       Click on advanced options to see below check boxes. to match full cell values then check on the box.

4. Now the values in the column are replaced.

Hope this helps you.

Supercharge your business intelligence skills with our MSBI Course – Enroll now!

Also, Elevate your data analysis skills to expert levels with our in-depth Mastering Power BI Program. Gain the advanced expertise to analyze, visualize, and report data like a pro.

Comments

Thank you very much! Very clear, usefull info for a starter like me.

---

Glad to help!

---

Hello @Diego, please upvote @Cherukuri's answer if it has helped you.

Register at Edureka Community and get points for contributing(asking, answering and commenting).

Answer 2

In my case:

Select the cell value you want to change(select null in this case) in Query Editor. 2. Click "Replace Values" option under Home tab. Then you should be able to change null to "Unspecified" 

The ISNULL Function is a built-in function to replace nulls with specified replacement values. To use this function, all you need to do is pass the column name in the first parameter and in the second parameter pass the value with which you want to replace the null value.

Unlock the Power of Data with Our Comprehensive Power BI Training!

Answer 3

In addition, have you tried the "Replace Values" option within Query Editor? It should also work.

1. Select the cell value you want to change(select null in this case) in Query Editor.

2. Click "Replace Values" option under Home tab. Then you should be able to change null to "Unspecified" like below.

Learn How to replace Blank with 0 in Power BI Visual?