Forum Discussion
Microsoft Employee(Blank) display substitute option
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.
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
2 Replies
v-qiuyu-msftCommunity Support
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
Chapin4uThanks for the great tip