Empty card visual until slicer option selected

[at997]

Hello, 

I have a customer number slicer, and I would like to display their names in a multi row card on the side. However, I want the card to be blank until something in the slicer is selected. The DAX Formula below is the closest I have gotten, but this only works with single selection slicers, and my customer slicer has to be multi select. 

Single Select DAX Formula:

IF(HASONEFILTER('Customers Table'[CustomerNo]),VALUES('Customers Table'[CustomerName]),"Select Customer Number")

Is there any way (DAX Formula or Visual filter) to allow there to be an empty card until  single OR multiple slicer options are selected?  

Any help would be appreciated 🙂

[Anonymous]

@at997,

It is not possible to show data when multiple options are selected in this case, as per the following article, HASONEFILTER() will return blank() when more than one filter are selected.

https://msdn.microsoft.com/en-us/library/gg492135.aspx


Regards,
Lydia