topic Re: Card for Slicer Selection in DAX Commands and Tips

Card for Slicer Selection

roncruiser — Tue, 28 Mar 2023 19:34:39 GMT

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-7 in green selected then "Sub".
If only 220 selected then "High".
If there are random selections then "Multiple".

This will be for a title of a chart. I'm working with selectedvalue but with no success so far. Still going at it.

Re: Card for Slicer Selection

amitchandak — Wed, 29 Mar 2023 04:59:32 GMT

roncruiser ,

Switch(

isblank( Selectedvalue(Table[Column])) , "All",

Selectedvalue(Table[Column]) *1 <=7, "Sub"

Selectedvalue(Table[Column]) *1 =220, "High"

//add other conditions

)

Re: Card for Slicer Selection

roncruiser — Thu, 30 Mar 2023 20:33:34 GMT

amitchandak

Thank You for the reply.

Maybe there is somethings I am missing as it is not working for me. I created the measure and
dropped it into a card and choose the slicer settings but get the following....

Not sure what I am doing wrong.

Re: Card for Slicer Selection

Anonymous — Thu, 30 Mar 2023 21:32:22 GMT

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

Re: Card for Slicer Selection

roncruiser — Thu, 30 Mar 2023 22:42:36 GMT

Anonymous

Hi Max,

I do not know what [ct] means with respect to the expression. I do not have a column "ct" in my table.
Should I use an use an explicit measure to get count? Does ct = count?

Thanks.
Ron

Re: Card for Slicer Selection

roncruiser — Thu, 30 Mar 2023 23:24:31 GMT

Anonymous

I commented out the line for "Multiple". I still do not know what [ct] mean. Until that is clear, I can leave that out.
As you can see, even when nothing is selected "All" does show up in the card.
Along the same lines, selecting 0-7, "Sub" does not show either on the card.

I'll play with your expression to see if I can get it to go.

Thanks for the response.
Any further help is appreciated!

Re: Card for Slicer Selection

roncruiser — Mon, 03 Apr 2023 13:31:16 GMT

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.

Re: Card for Slicer Selection

roncruiser — Fri, 03 May 2024 21:35:04 GMT

Thank you Anonymous Max. I revisted this and was able to implement your measure.