cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bdenny Frequent Visitor
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

Accepted Solutions
bdenny Frequent Visitor
Frequent Visitor

Re: Card showing Blank instead of 0

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

4 REPLIES 4
Highlighted
quentin_vigne Senior Member
Senior Member

Re: Card showing Blank instead of 0

Hi @bdenny

 

Can you try this ? :

 

Measure = Blad1[CurrentStatus] + 0

Use this measure in your card 

 

- Quentin

bdenny Frequent Visitor
Frequent Visitor

Re: Card showing Blank instead of 0

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

quentin_vigne Senior Member
Senior Member

Re: Card showing Blank instead of 0

You're welcome

 

 

Have a good day

 

- Quentin

jkim62 Visitor
Visitor

Re: Card showing Blank instead of 0

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

 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

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

Top Ideas
Users Online
Currently online: 44 members 1,018 guests
Please welcome our newest community members: