visualization not showing blank values

[C097986]

Hey guys,

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

for example, i have 4 different status:

Status	Count of AEF
Draft	0
Submitted	34
Approved	55
Rejected	5

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.

[v-piga-msft · Accepted solution]

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

[C097986]

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.