Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
79 | |
78 | |
59 | |
36 | |
33 |
User | Count |
---|---|
94 | |
61 | |
56 | |
49 | |
41 |