cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bdenny
Frequent Visitor

Card showing Blank instead of 0

Hi,

 

I'm aware that this question has been asked many times but I don't want to hijack any topics.  The answers given in those topics didn't work for me.

 

I've created a dashboard and I use 4 seperate cards that counts how many files are in which status; New, Under Investigation, 4-eyes, Closed. Datatype is text. When you filter on month and there aren't any files in tjht particular status then it shows Blank instead of 0. 

 

I've tried new column and a new measure with this DAX-formula and used that new column in the card but it still shows Blank:

 

New Measure = if(ISBLANK([Blad1[CurrentStatus]]),0,[Blad1[CurrentStatus]])

 

Are there any other tricks?

 

 

1 ACCEPTED SOLUTION

Hi Quentin,

 

Thank you for your reply. I've tried it but I had to add a function like SUM or COUNT or else it wouldn't accept it.

So now I have this and that works! 

 

Measure = COUNT(Blad1[Huidige status]) + 0

 

So thank you for guiding me to the right answer! Smiley Happy

View solution in original post

6 REPLIES 6
jammobj
New Member
quentin_vigne
Solution Sage
Solution Sage

Hi @bdenny

 

Can you try this ? :

 

Measure = Blad1[CurrentStatus] + 0

Use this measure in your card 

 

- Quentin

Hi Quentin,

 

Thank you for your reply. I've tried it but I had to add a function like SUM or COUNT or else it wouldn't accept it.

So now I have this and that works! 

 

Measure = COUNT(Blad1[Huidige status]) + 0

 

So thank you for guiding me to the right answer! Smiley Happy

View solution in original post

jkim62
Frequent Visitor

this doesn't seem to be good solution.

I have 16 cards then i have to create 16 measures? 

ms should implement something like "Show 0 when Blank" in the red circle down below the capture.

capture.png

 

/k

 

Totally agree.

You're welcome

 

 

Have a good day

 

- Quentin

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

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

Top Solution Authors
Top Kudoed Authors