how to change the <blank> on card visualization

[ChenChristyYu]

Hi guys,

I am using a card visualization to show the count of rows, but some tables simply do not have any qualified row. Is there a way I can have it shown as 0 instead of <blank>. BTW, the dropdown is frozen. Can someone help on this?

Thanks so much.

[v-jiascu-msft · Accepted solution]

Hi @ChenChristyYu,

Seems you added the column in the filed directly. Maybe you need a measure like this:

Measure =
IF ( ISBLANK ( COUNT ( Table1[DATE] ) ), 0, COUNT ( Table1[DATE] ) )

Best Regards,

Dale

[Seth_C_Bauer]

@ChenChristyYu Be cautious with this because it could impact the calculations in other areas in unwanted ways, but you can just throw a "+0" at the end of the equation in the measure and it should produce a 0 instead of blank.