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
in Power BI by 11 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 23 26 40
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!