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

 
 

 

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

     

5 Replies

  • 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