Display a message on selecting incorrect value in slicer and show the visualisation as blank

[Anonymous]

Hi Team,

Greetings!!

I came across a requirement, wherein I have a slicer with the values as ABC, XYZ, DEF. Now there are two things that are required.

1. In the slicer, the value DEF must be always selected by default. (I hope this can be partially achieved by Chiclet Slicer)

2. If any user deselects the value DEF and selects ABC and XYZ, then I need to display a message on a multi row card that only two values can be selected and one of them has to be 'DEF' and also the visualisation should show as blank.
Note: I need to select only two values and not all three togther.

May I request you to kindly assist me on this.

Thanks,

Ani91 

[Greg_Deckler · Accepted solution]

Try this:

Slicer Verify = 
VAR slicerCount = COUNTROWS(Slicer)
VAR containsDEF = CONTAINS(Slicer,Slicer[Value],"DEF")
RETURN IF(slicerCount = 2 && containsDEF,"Selection OK","Please pick 2 and must contain DEF")

[Anonymous]

Hi Greg

This worked amazingly. Thank you so much.
Just a further question, On incorrect selection, i.e. if the selection does not contain DEF then the visualizations should go blank. Can this be achieved?

Thanks.