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.
Hello,
i want to show selected values from slicer on a card. When I don't select anything in slicer, i want to see "All" on card, when i select single value , i want to see single value and when i select multiple values, i want to see these multiple values.
could u pls help.
thanks
Hi @GrimReaperX
please try
Selected Values =
IF (
ISFILTERED ( 'Table'[Columm] ),
CONCATENATEX ( VALUES ( 'Table'[Column] ), 'Table'[Column], ", " ),
"All"
)
User | Count |
---|---|
17 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
9 | |
8 |