Forum Discussion
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?
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.")
3 Replies
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.")
Not ideal, but it'll work! Thanks for the suggestion!
DesireeSAdvocate I
In theory, there is a "force selection option" on the slicer
but it is currently not working, and if I understand the posts here, its been broken for at least a year.
My use case:
I have slicer A that filters the options of slicer B (but not the other way 'round). Slicer B is being filtered to the options I want, but none of them are "force selected", so everything else looks blank and awful. I am going back and forth between using a chiclet slicer instead (which does actually force select) or having a card under each chart that says "Please select from slicer B to view data". I started using PBI about 4 years ago and the chiclet slicer was the best option then and I am quite frankly surprised that it's still the best option now. I'd thought that Microsoft would see the value in the chiclet slicer and learn something.
