Forum Discussion
Empty card visual until slicer option selected
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 :)
1 Reply
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
