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

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

You're welcome

 

 

Have a good day

 

- Quentin

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.

New Member

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors