How to replace null values in power bi?

Question

I got data from excel and I loaded it to power bi, when I transform data I noticed that there are null values. how to replace all null values with zero in Power BI desktop?

Answer 1

In Power BI, to replace null value or any other value follow these steps:

1. Click on "Edit Queries" to access the Power Query Editor.

2. In the Power query editor > click on the Transform tab > click on Replace values
   

3. Write the value you want to find and the value you want to replace and click ok.