How do i replace all incoming null values? My data source is a sharepoint list

[Anonymous]

In sharepoint list, the user has to pick yes or leave it empty which will add an entry as "flase" My data contain answer for a while ago so all old values are "null". All the recent answers are either "true" or "false". How do i replace all the null values? And I am not 100% sure that there wont be any more null values in the future.

Also I'm new to power bi. Please keep your answer noob friendly

[Anonymous]

Hi @Anonymous ,

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy · Accepted solution]

@Anonymous 

In Power Query,  Right-Click a null value and choose Replace Value then click OK. This replaces any null in that column when you refresh the data.

[Anonymous]

I'm currently using this but what if there are more null values in the future? also there are a lot of null values and i replace all of them everytime.

[Fowmy]

@Anonymous 

No worries', it will be replaced in the future as well when you refresh your data.