How to replace null values in Power BI

+2 votes
How to replace null values with custom values in Power BI(power query editor)?
Mar 8, 2019 in Power BI by Nithin
161,716 views

3 answers to this question.

+1 vote

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.

answered Mar 8, 2019 by Cherukuri
• 33,030 points
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).
0 votes

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!

answered Dec 11, 2020 by Gitika
• 65,770 points
0 votes

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

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

c1.PNG

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

r1.PNGr2.PNGr3.PNG

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

answered Dec 11, 2020 by Rajiv
• 8,870 points

Related Questions In Power BI

0 votes
3 answers

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

so you are using the raw source ...READ MORE

answered Dec 15, 2020 in Power BI by Gitika
• 65,770 points
109,479 views
0 votes
1 answer

How to combine your data or tables in Power BI?

Power BI includes Query Editor which is ...READ MORE

answered Feb 27, 2019 in Power BI by Phalguni
• 1,020 points
3,061 views
0 votes
4 answers

How to combine multiple tables in power BI?

Click Advanced Editor and check if step #"Appended ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,480 points
74,116 views
0 votes
1 answer

How to show filtered vs total data in power BI?

Hi sindhu, Follow below steps to show filtered ...READ MORE

answered Mar 26, 2019 in Power BI by Cherukuri
• 33,030 points
4,896 views
0 votes
1 answer

How To use R Integration in Power BI?

Hi,  There are a lot of packages available ...READ MORE

answered May 3, 2019 in Power BI by Avantika
• 1,520 points
2,700 views
0 votes
1 answer

How to categorize state, pin and city in power bi (Address)

After loading dataset, you can split in ...READ MORE

answered May 10, 2019 in Power BI by anonymous
• 33,030 points
3,697 views
0 votes
1 answer

How to sum a data table in Power BI?

It's a good practice if you avoid ...READ MORE

answered May 17, 2019 in Power BI by Avantika
• 1,520 points

edited May 17, 2019 by Omkar 7,654 views
0 votes
1 answer

How to Export data in Power BI online version?

Hi, You can export your data from any ...READ MORE

answered May 27, 2019 in Power BI by Avantika
• 1,520 points
1,173 views
0 votes
1 answer

How to Install Power BI in Windows

Hi, Anitha Go to this Link https://powerbi.microsoft.com/en-us/downloads/ Then click on ...READ MORE

answered Feb 28, 2019 in Power BI by Cherukuri
• 33,030 points
1,207 views
0 votes
3 answers

How to create final table based on Joins of two tables in power BI?

To do so, follow these steps: From the ...READ MORE

answered Dec 16, 2020 in Power BI by Gitika
• 65,770 points
56,350 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP