cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
2 REPLIES 2
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

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

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

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 388 members 3,330 guests
Please welcome our newest community members: