Zero Instead of Blank on Dashboard

[Anonymous]

Hi,

I have seen a lot of post on this but this is a bit different I do not want a zero in my data but on the Visualisation card wherein if data is not available for a month for the X card then it should show 0 instead of Blank.

As shown below when I select time period April, 2018 to July, 2018 then Attrition Rate is 0 but what i get is Blank.

 Is it poosible to have a measure for the entire page wherein if there are no data for any matrix card then should give me 0 instead of Blank.

Thanks!

Regards,

DK

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

Based on my test, We can create the measure like this to meet your requirement.

Measure = SUM(Table1[Column3])+0

Then if the result is blank, we can get the result 0 instead of blank.

For more details, please check the pbix as attached.

https://www.dropbox.com/s/qiwto1fo7hqoatl/Zero%20Instead%20of%20Blank%20on%20Dashboard.pbix?dl=0

Regards,

Frank

[v-frfei-msft]

Hi @Anonymous,

Does that make sense? If so, kindly mark my answer as a solution to close the case please.

Regards,

Frank

[muhammadb]

Hi Frank, 

I'm fairly new to Power BI and your solution helped resolve a similar issue described in the original post. Could you explain to me how your solution works so I can develop a greater understanding? 

Thank you 

Kind regards

Muhammad