Card showing Blank instead of 0

[bdenny]

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?

[Anonymous]

Hi, 

You can hide the blank value using a Conditional Formatting rule on the Call Out Value. The rule is 'if blank', then select the same color as the card or canvas background. 

I have created a video tutorial on how to create the conditional rule on the value: https://youtu.be/Xsmbfpa4oCA

Cheers, Bianca

[jammobj]

https://www.youtube.com/watch?v=Y8uC-bri_xg&t=1476s

https://www.youtube.com/watch?v=VpTHH9IcEF8&t=3s

[quentin_vigne]

Hi @bdenny

Can you try this ? :

Measure = Blad1[CurrentStatus] + 0

Use this measure in your card 

- Quentin

[bdenny · 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!

[jkim62]

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.

/k

[Anonymous]

This is the most useful statement I have seen so far on this topic. I am in the same situation with multiple cards. If I have to create a new measure for each, then the power of power BI is lost on me. Is there still no fix for this issue?

[Anonymous]

Totally agree.

[quentin_vigne]

You're welcome

Have a good day

- Quentin