Forum Discussion
Default Slicer to none selected
I have two slicers on a labor analysis page. One is for Employees and the other for Subcontractors. I want to be able to filter from either Employees, Subcontractors, or both. If I filter b...
What you can do with the new feature of Field Parameters (check in Preview features):
- Create a Column Called None with all blank values of ""
- Create a Field Parameter to select None field as well as the other fields you want (this lets you combine the fields together into 1 Slicer).
- Make Field Parameter into a Slicer.
- Now you will have a Slicer with None option that will give a blank result. Select for this as the default to not show any results. Save the dashboard in this state to keep the selection this way. You can select the other fields to populate data.