Showing results for 
Search instead for 
Did you mean: 
sonamyan Frequent Visitor
Frequent Visitor

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
itsmebvamsi Regular Visitor
Regular Visitor

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




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



sonamyan Frequent Visitor
Frequent Visitor

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

Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 5 members 3,282 guests
Please welcome our newest community members: