Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
User | Count |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
95 | |
93 | |
91 | |
75 | |
69 |