How to remove BLANK on a card visual without DAX

[AndrewRust88]

Hey all,

I am new to Power Bi and have come across this of which I can't figure out a way to overcome. I know it can be done using DAX but I rather not make all the visuals again in DAX just to remove BLANK.

The issue I have is when I drag my column onto a Card visual, I then filter it to just id 3 (this being Actions Completed).

At the 'All Retailer' level slicer that shows 2300 Completed Actions, But when I select a retailer this visual changes to BLANK as this Retailer has no completed Actions yet.

My question is instead of BLANK can I show 0 or nothing? or do I have to write a DAX statement instead to deal with it?

Thank you for your help and time

[Anonymous]

Hi, 

You can hide the blank value using a Conditional Formatting rule on the Callout Value.

I have created a video tutorial on how to apply the conditional formatting: https://youtu.be/Xsmbfpa4oCA

[v-yulgu-msft · Accepted solution]

Hi @AndrewRust88,

There is no direct way to change BLANK to 0 when there is no corresponding value to shown in card visual, unless you write DAX formula with condition statement.

Regards,

Yuliana Gu

[Anonymous]

Hi @v-yulgu-msft

What is the proper DAX to use?

I have something like:

IF( ISBLANK( [measure] ), BLANK(), [measure] )

but this still shows (blank) in the card.

[parry2k]

@AndrewRust88you have to write the DAX without that , if data is getting filtered, your card visual will show blank

[Anonymous]

Put the measure in Filters and filter out Blank. Maybe I didn't understand.