cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Su_Prasad
Regular Visitor

Re: Replacing (Blanks) with 0

There is a simpler solution, 

Click on "Edit Queries" ribbon in the toolbar
Select the "Database"(Incase if you have multiple database imported into PBi )
Select the respective "Column" in that databse which has blanks
Choose the option "Replace Value"
Value to find: null
Replace with: 0
Click ok

 

Taaadaaa!! 

Highlighted
rodlovely
Regular Visitor

Re: Replacing (Blanks) with 0

If you want is to replace blank or null values with 0 without creating a new column, then use the Query Editor.

  1. Select Edit Query. 
  2. In the query window, right click on the column header and select Replace Values... 

Notes:

  • Pay attention to where you insert the command in your Query steps. 
  • You can select multiple columns by holding down the Ctrl key when you select the column header
  • You can view and modify the code in the Advanced Editor if needed.
  • You can replace any values with this method

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors