Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
109 | |
89 | |
76 | |
67 |
User | Count |
---|---|
125 | |
111 | |
100 | |
83 | |
71 |