Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
4.2k views
in Power BI by 7 11 15

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?


1 Answer

0 like 0 dislike
by 9 24 38
selected by
 
Best answer

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
    Replace values in Power BI

  3. Write the value you want to find and the value you want to replace and click ok.
    replace null with zero in Power BI

If you don’t ask, the answer is always NO!
...