Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi.
I want to create a Card where I can see wich elements of a particular slicer are selected but i don´t have a clue on how to do it, so far I can only put a single field selection using this DAX: Flor Actual = IFERROR(FILTERS('BD Final'[Flor GR]);"(Multiple Selection)")
I use the IFERROR so in case I have more than one field selected at the "Flor GR" slicer the Card just shows "Multiple Selection" but I want to be able to have multiple items selected and the Card shows me what i have selected.
Thanks.
Solved! Go to Solution.
Hi @Anonymous,
I think this Measure shoud help.
Hi @Anonymous,
I think this Measure shoud help.
Hi @Mariusz it works perfectly thank you so much!!
Now I would like to know if ther is a way that if have everything or nothing selected at the slicer the card instead of showing me the whole list just says "All selected".
Hi @Anonymous
Please see the below
Selected Slicer Values =
VAR s = VALUES('Product'[Brand])
VAR c = COUNTROWS(ALL('Product'[Brand])) = COUNTROWS(s)
RETURN
IF(
c, "All Selected",
CONCATENATEX(
s,
'Product'[Brand],
"; "
)
)Always happy to help.
Mariusz
I have a need similar to this one... let me know if I should post separately but this thread is closest I can find so far...
So this user wanted to show all selected... I want to show "MULTI" or "Multiple" if a user selects more than one selection... How can I do this?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 61 | |
| 44 | |
| 41 | |
| 36 | |
| 21 |
| User | Count |
|---|---|
| 176 | |
| 120 | |
| 106 | |
| 77 | |
| 52 |