cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mikechittick Frequent Visitor
Frequent Visitor

Force a selection in a drop-down slicer

I have a report which requires that a selection is made in a dropdown slicer before clicking on a button which navigates to another page.  The other page has synced slicers, which means it only works if a selection is made.  Unfortunately, the default value is "All" on a dropdown, and I can't figure out how to force a selection from the slicer.  Any ideas?

~Mike Chittick
Business Analytics Lead
Inviso Corporation
1 ACCEPTED SOLUTION

Accepted Solutions
SonnyChilds Established Member
Established Member

Re: Force a selection in a drop-down slicer

The only thing I can think of is manually selecting a value you know will be there for anyone viewing the report. This will make it default to that value, and they won't have the ability to "Select All' unless they hit the eraser. You might utilize SELECTEDVALUE() in a measure on that page for some sort of feedback if they circumvent your one-only restriction.

 

Valid Selection = IF(ISNUMBER(SELECTEDVALUE(Data[ID], "xxx")), "Please click 'Submit'", "Please select a single ID before submitting.")

 

 

 

image.pngimage.png

2 REPLIES 2
SonnyChilds Established Member
Established Member

Re: Force a selection in a drop-down slicer

The only thing I can think of is manually selecting a value you know will be there for anyone viewing the report. This will make it default to that value, and they won't have the ability to "Select All' unless they hit the eraser. You might utilize SELECTEDVALUE() in a measure on that page for some sort of feedback if they circumvent your one-only restriction.

 

Valid Selection = IF(ISNUMBER(SELECTEDVALUE(Data[ID], "xxx")), "Please click 'Submit'", "Please select a single ID before submitting.")

 

 

 

image.pngimage.png

Highlighted
mikechittick Frequent Visitor
Frequent Visitor

Re: Force a selection in a drop-down slicer

Not ideal, but it'll work!  Thanks for the suggestion!

~Mike Chittick
Business Analytics Lead
Inviso Corporation