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.

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

Card for Slicer Selection | Microsoft Fabric Community

7 Replies

Anonymous
Not applicable
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
  Post Patron
  3 years ago
  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
- roncruiser
  Post Patron
  2 years ago
  Thank you Anonymous Max. I revisted this and was able to implement your measure.
amitchandak
Super User
3 years ago
roncruiser ,

Switch(

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

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

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

//add other conditions

)
- roncruiser
  Post Patron
  3 years ago
  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.
roncruiser
Post Patron
3 years ago
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!
roncruiser
Post 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.