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

+1 vote

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

Mar 8 in Power BI by Nithin
3,635 views

1 answer to this question.

0 votes

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.

answered Mar 8 by Cherukuri
• 25,820 points
Thank you very much! Very clear, usefull info for a starter like me.
Glad to help!

Related Questions In Power BI

+1 vote
1 answer

Have column with multiple values in powerBI, for use with a slicer in power bi

It can be achieved depending on the result you ...READ MORE

answered Oct 22, 2018 in Power BI by Hannah
• 14,070 points
1,858 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 in Power BI by Phalguni
• 1,010 points
74 views
0 votes
1 answer

How to combine multiple tables in power BI?

Hi Sindhu, You can merge the 3 tables ...READ MORE

answered Mar 14 in Power BI by Cherukuri
• 25,820 points
759 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 in Power BI by Cherukuri
• 25,820 points
78 views
0 votes
1 answer

Chart with only some values in field in a graph in power BI?

Hi Banu, While creating a chart, put the ...READ MORE

answered Apr 10 in Power BI by Cherukuri
• 25,820 points
29 views
0 votes
1 answer

How to use Python Scripts in Query Editor?

Hi, In order to use Python Visuals you need ...READ MORE

answered Apr 10 in Power BI by Avantika
• 1,500 points
163 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 2 in Power BI by Avantika
• 1,500 points
85 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 9 in Power BI by anonymous
• 25,820 points
32 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 in Power BI by Cherukuri
• 25,820 points
31 views
0 votes
1 answer

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

Hi Nithin, It is easy and simple. 1. Go ...READ MORE

answered Mar 1 in Power BI by Cherukuri
• 25,820 points
131 views