Forum Discussion

roncruiser's avatar
roncruiser
Icon for Post Patron rankPost Patron
3 years ago
Solved

Card for Slicer Selection

Hi, I'd like to see within a card a comment based on selection of the slicer. I'm not sure how go about this. This is the slicer: If "Selected All" or none selected then "All". If all 0-...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi,

     

    this should do the trick:

     

    Switch(
        TRUE(),
        DISTINCTCOUNT('Table'[column]) = CALCULATE(countrows('Table'), ALL('Table')), "All",
        DISTINCTCOUNT('Table'[column])>1 ||  DISTINCTCOUNT('Table'[ct]) > CALCULATE(countrows('Table'), ALL('Table')) -1, "Multiple",
        VALUE(Selectedvalue('Table'[column]))*1 <= 7, "Sub",
        VALUE(Selectedvalue('Table'[column]))*1  =220, "High"
    )
     
    Regards,
    Max
roncruiser's avatar
roncruiser
Icon for Post Patron rankPost Patron
3 years ago

I likely was not clear with the card expectations.
amitchandak 
Anonymous 

Here's a better example:

Slicer settings:

 if none selected.  Card reads "none".

 if all selected. Card reads "All".

 if all selected as shown. Meaning all of 0-1-2-3-4-5-6-7 are selected at the same time. Card reads "Sub".

 if only "220" is selected as shown. Card reads "High".

Thanks for the attemped solutions, but none of them met the criteria or did something entirely different than intended.

I tried to play around and modify the solutions but still could not get them to work.
Still seeking help please.