The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi Expert,
I want to display multiple selected value from single slicer in a card/table. Would you please help me to write dax/measure?
Client wanted to see all the selected values from slicer on the report.
Any help would be highly appreciated.
TIA
Solved! Go to Solution.
Hi @Uzi2019
Create a measure like this and place it in a card. If nothign is selected it displays the message "No Selection" - chnage that to anything you like.
Selections = IF(ISFILTERED('DataTable'[Values]),CONCATENATEX(VALUES('DataTable'[Values]),'DataTable'[Values],", "),"No Selection")
Regards
Phil
Proud to be a Super User!
Hi @Uzi2019
Create a measure like this and place it in a card. If nothign is selected it displays the message "No Selection" - chnage that to anything you like.
Selections = IF(ISFILTERED('DataTable'[Values]),CONCATENATEX(VALUES('DataTable'[Values]),'DataTable'[Values],", "),"No Selection")
Regards
Phil
Proud to be a Super User!
Thanks alot. It really worked.