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.

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.

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.