Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 DA...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi Anonymous,

    I think this Measure shoud help.

     

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

    Hope this helps 
    Mariusz

     

Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi Anonymous,

I think this Measure shoud help.

 

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

Hope this helps 
Mariusz

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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".

    • Mariusz's avatar
      Mariusz
      Community Champion
      7 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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?