Once you have added a slicer from Discover or built a new slicer using the Advanced Slicer Wizard or New Slicer toolbox option, you can open a panel containing advanced settings for the Slicer. These Slicer Settings set the default behavior of the slicer, and allow you to configure the type of elements used in the slicer (for example, if you want to create a slicer based on a custom list or a hierarchical structure from a cube datasource).
Open the Slicer Settings panel
Configure the slicer settings to determine the default behavior of the slicer. To open the Slicer Settings panel, right-click on the slicer and select Slicer Settings.
Note: If the panel name is not "Slicer Settings" but "New Slicer," then you are seeing this panel when creating a new slicer in Present. For more information about the fields in the New Slicer panel, see Advanced Slicer Wizard.
Slicer Settings panel
Type
Change the slicer's title and type.
Load Time
Determine which of the slicer's elements will be automatically loaded when the report is opened.
Slicer Elements Limit
Set the maximum number of slicer elements to include in the slicer. The limit set here cannot exceed the limit set from the user defaults.
Search Type
Set the search type; this will be applied to any slicer type that supports search (drop-down, text box, and tree).
Other Options
Disable and enable the filter button, background chips, and auto run for the slicer.
Elements
Select those elements that should be included on the slicer when your presentation is used at runtime. As an example, if you have a Country slicer, you might want to limit the selectable elements to those countries in a particular region, making the slicer more usable and data more relevant to the users in that region.
When configuring the elements on your slicer, you may see different options on the Elements panel:
- If your slicer is linked to a visual in Discover, you will see the Linked Discovery view.
- If your slicer is a "one-off" that only exists here, you will see the Unlinked Discovery view.
Linked Discovery
If your slicer was created in Discover, and has not been unlinked, you will see the following in the Elements panel:
You need to make a choice about where to make your changes:
- If you want the changes to your slicer's elements to impact the original slicer and any other presentations or publications that it currently appears in, click Linked Discovery to open the visual in Discover and edit the Slicer Settings elements in there. Any changes you make will apply to all instances of the slicer.
- If you only want to make changes to the slicer here, and you are happy to lose the connection between the instances of the slicer, click Unlink to break the link between your slicer and the linked discovery. Breaking this link means that the slicer is no longer connected to / affected by changes to the slicer in Discover. Once the slicer is unlinked, the Unlinked Discovery view is shown.
Warning: Unlinking a slicer from its discovery is permanent. Any changes you make to the discovery after it has been unlinked will not affect this slicer. You must be sure that you want to unlink your slicer before you click Unlink.
Unlinked Discovery
If your slicer is a "one-off" that only exists here (it is not linked to a discovery), then your changes only impact the slicer here. This is the case where the slicer was created on-the-fly or where it has already been "unlinked" from its Discovery as described above.
Where the slicer is a "one-off," the Elements panel appears as follows:
Select those elements that you want to include on the slicer using one of the following mechanisms:
- Free Selection: Select the elements from the hierarchy that you want to include on the slicer.
- Level: This option is relevant when working with OLAP or Tabular hierarchies, or regular SQL hierarchies. When creating a slicer based on a regular hierarchy, select this option to specify a particular level of the given hierarchy.
- Lists: Choose this option to use a custom list as the slicer.
Non Empty Filter
Go to the Non Empty Filter tab, to hide empties from the slicer. For more information, see Empties Logic.