cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

visualization not showing blank values

Hey guys,

      I am trying to show count of values with different status options.

for example, i have 4 different status:

StatusCount of AEF
Draft0
Submitted34
Approved55
Rejected5

 

So I have made a card that shows this data as it's values. Now if i just select Draft (on a status slicer), the card shows "(Blank)". Is there a way for the card to show 0 instead of blank written out?

 

Thank you for your help in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Resident Rockstar
Resident Rockstar

Hi @C097986,

 

You could create a measure by IF(ISBLANK(),0, ) like below to get your expected output.

 

New Measure = if(ISBLANK([count Measure]),0,[count Measure])

In addition, you could have a reference of this similar thread.

 

You also could vote this similar idea here which has been submitted in Power BI ideas forum and add your comments there to improve Power BI and make this feature coming sooner.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Resident Rockstar
Resident Rockstar

Hi @C097986,

 

You could create a measure by IF(ISBLANK(),0, ) like below to get your expected output.

 

New Measure = if(ISBLANK([count Measure]),0,[count Measure])

In addition, you could have a reference of this similar thread.

 

You also could vote this similar idea here which has been submitted in Power BI ideas forum and add your comments there to improve Power BI and make this feature coming sooner.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

thank you, I read through all the thread and this is what i used but using an IF measure sure seems very inefficient if there multiple cards present. I voted for a better fix and all i hope is that they make simple changes like these in their next upgrade.

thank you for your help.

 

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

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