(Blank) display substitute option

[Chapin4u]

Hi,

When using a card visual is there any way to substitute or replace the (Blank) display on the card visual for " " like Excel.

Thanks in advance for any tip that I can get.

[v-qiuyu-msft · Accepted solution]

Hi @Chapin4u,

You can try to create a new measure to return " " when the original measure returns the blank() like below:

New Measure = if(ISBLANK([Original Measure])," ",[Original Measure])

Also there is a same idea which you can vote on it: When Blank() function is used in DAX it should return nothing instead of word (blank).

Best Regards,
Qiuyun Yu

[Chapin4u]

Thanks for the great tip