A slicer comprises a list of member elements from a model hierarchy and is used to filter the query by one or multiple member elements at runtime. For instance, if you add the Country hierarchy, you can filter the query by any country in that hierarchy via the slicer selection. Slicers can also be used with measures to drive a slightly different mechanisms. This includes:
- a "switching" effect, where the measure can be swapped out using the measure slice. These are known as variable measure sets.
- a "parameterization" effect, where a VALUE filter can be built using a given measure to numerically filter the query. (see below for more)
- Click here for more on Slicers in Discover.
- Drop Down: adds a drop down list, from which one slice can be selected at a time.
- Multi Select Drop Down: adds a drop down list, from which multiple slices can be selected simultaneously.
- List Box: adds a single-select list within a box container.
- Multi Select List Box: adds a multi-select list within a box container.
- Text Box: adds a textbox with drop-down.
- Buttons: adds single-select buttons, rather than a list.
- Multi Select Buttons: adds multi-select buttons.
- Multi Select Tree: supports 'regular' hierarchies in both cube and SQL models. Adds a multi-select tree list; navigate through the tree to find and select relevant elements.
- Single Select Tree: supports 'regular' hierarchies in both cube and SQL models. Adds a single select tree list; navigate through the tree to find the relevant element.
- Date-Time Picker: the date-time picker is a specialized slicer visualization is designed to make it easier to use date-time hierarchies and their associated calculations.
You can search slicer elements in drop down, list box, and tree slicers via the slicer search bar.
When using multi select drop down, list box, or tree slicers, the search will return all elements matching the given search input. You can select all the returned results by clicking "All Filtered Items".
Actions can be attached to slicers in Present, so that when a user changes the slicer in runtime, it triggers an effect (other than filtering queries). Click here for more on slicer actions.
Adding Slicers to a Presentation
There are various options for adding slicers to presentations:
- Add an existing slicer that was built in Discover (see below)
- Build a new slicer on the fly in Present
- Configure an advanced slicer in Present
- Add Hidden Slicers, rather than on-slide slicers
- Add multiple slicers and cross filter them to create a cascading slicer effect
- Add multiple slicers and apply cross highlighting to them
- Add slicers by reusing previously defined slicers in existing Discover Reports (see below)
Slicers in Present are configured by applying interactions from slicer to visual, and from slicer to slicer.
Adding slicers from Discover to presentations is a simple process achieved in just a few steps.
To add existing slicers to other slides in the presentation, find the required slicers in the Content panel (yellow highlight below).
Drag the slicer onto the canvas (yellow arrow below).
Add interactions between the slicer and any visualizations that the slicer should filter.
To test your slicer, launch the presentation in runtime.