cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Replace 'Blank" values with Zero on the Visualization

Hello everyone, I am having a hard time replacing the "Blank" values with Zeros on my visualization. The main visualization type I use to show numbers is "Card". Whenever I apply any filter, and there is no value for that, it shows 'Blank". I want to see 0 instead. I am not sure if it needs to be done through replacing the data on the report before uploading it to Power BI or on the dashboard itself by creating a new measure? Thanks for your help, Sona
2 REPLIES 2
Highlighted
Resolver III
Resolver III

Re: Replace 'Blank" values with Zero on the Visualization

@sonamyan you can do this in two ways, 1) In query editor 2) Using new calculated measure

 

1) In Query editor:

 

1) in your power bi desktop click on edit queries

2)select column right click on it

3)choose replace value

4)enter "null" in find value in "replace value enter "0"

5)close and apply

 

you should see "0" wherever you have nulls in that column

One.png

 

 

2)Using new calculated measure

 

Create new measure using following code 

 

Sales_WO_Blanl = IF(ISBLANK(Sheet2[SalePrice]),0,Sheet2[SalePrice])

use this as a card . FYI see the attched PBIX

 

Two.PNG

Highlighted
Helper II
Helper II

Re: Replace 'Blank" values with Zero on the Visualization

Hello @itsmebvamsi, Thank you so much for your help. Neither ways worked actually. I use Count Distinct function for the data item (its an application number for participants). I also have another filter applied to that, so the total number of app numbers I have is 8, when I apply one of the filters, it shows blank while I want it to show Zero. Thanks, Sona

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors