Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Card visual with multiple selection slicer

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.

 
 

 

1 ACCEPTED SOLUTION
Mariusz
Community Champion
Community Champion

Hi @Anonymous,

I think this Measure shoud help.

 

Selected Values =
CONCATENATEX(
VALUES('Product'[Brand]),
'Product'[Brand],
"; "
)

Hope this helps 
Mariusz

 

View solution in original post

5 REPLIES 5
Mariusz
Community Champion
Community Champion

Hi @Anonymous,

I think this Measure shoud help.

 

Selected Values =
CONCATENATEX(
VALUES('Product'[Brand]),
'Product'[Brand],
"; "
)

Hope this helps 
Mariusz

 

Anonymous
Not applicable

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

@juanmg_92  

Could you please share sample BI file 
Please

Amardeep Bhingardeve
Anonymous
Not applicable

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?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors