please help me to fix this

[Anonymous]

Previously, I used a visual card to display the data but if the data is not available in that categories, it will show "Blank". This is a characteristic of my display data.

1. It is in text format.

2. All have distinct values in terms of text format (6 categories).

My problem is that I wish for my display data to be able to show "NA" or "0" instead of a blank. How can I do this?

[FreemanZ · Accepted solution]

hi @Anonymous 

try to feed the card with a measure like:

Measure = IF([data]<>BLANK(), [data], "NA")