Changing card visual to "N/A" for text value

[Anonymous]

Hi,

I've got regions displaying on my card and when none of them have been selected from the table on the left in the image, the first region is automatically displayed.

Instead of this, I want to display "N/A".

Any ideas on how I go about doing this?

Thanks in advance,

Michael

[PaulDBrown · Accepted solution]

@Anonymous 

Create a measure for your card as in:

Selected Items or Display NA = 
IF(ISFILTERED('DIM Item'), 
   CONCATENATEX('DIM Item', 'DIM Item'[Item], ", "), 
   "N/A")

Substitue "Dim Item" and "Dim Item [Table]" for the corresponding fields in your visual.

This will allow for multiple selections: