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

View solution in original post

6 REPLIES 6
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

View solution in original post

quentin_vigne Senior Member
Senior Member

Re: Card showing Blank instead of 0

You're welcome

 

 

Have a good day

 

- Quentin

jkim62 Frequent Visitor
Frequent 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

 

DavidsonLima Visitor
Visitor

Re: Card showing Blank instead of 0

Totally agree.

jammobj Frequent Visitor
Frequent Visitor

Re: Card showing Blank instead of 0

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors