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

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
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 212 members 2,264 guests
Please welcome our newest community members: