Advanced Slicer Wizard

Use this option to add slicers to presentations on the fly. This option enables the adding of slicers from any of your datasources.

The slicer must be configured in the New Slicer wizard, after which it is added to the presentation slide.

To add a new slicer to the presentation, go to the Home ribbon and select the New Slicer button (red highlight below). A new slicer can also be added from the Interaction Manager.

Add an Advanced Slicer

Configure the slicer from the New Slicer panel.

  • Click here for a more detailed review of the slicer settings.

Data Source

Choose the data source and slicer hierarchy:

Choose Model

Select the data model to connect to.

Select Hierarchy

Choose the hierarchy that will be used to build the slicer.

Elements

Choose the elements that will be included in the slicer. There are three ways to set the slicer's elements:

  • Free Selection: manually select the hierarchy's member elements that should be included in 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.
  • Set: choose this option use a custom list as the slicer.

Type

The Type settings let you change the slicer's title and type.

  • Title: edit the slicer title.
  • Type: select a slicer type from the drop-down menu.

Load Time

The load time settings determine which of the slicer's elements will be automatically loaded when the report is opened.

Initial Selection Mechanism

The initial selection mechanism determines which slice will be automatically loaded when the user opens the report.

  • Saved Selection by Name: select the initial slicer selection by name; this slice will be selected by default whenever the report is opened. Select the slice from the Initial Selections window.
  • Saved Selection by Position: select the initial slicer selection by position; this slicer will be selected by default whenever the report is opened. This is useful if the slicer is based on a custom calculation that shows, for example, the top 10 products. You might want to automatically load the top selling product. In this case, the slicer position needs to be saved. Select the slice from the Initial Selections window.
  • First Member: automatically select the first member in the slicer whenever the report is opened.
  • Last Member: automatically select the last member in the slicer whenever 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 settings.

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

From the Other Options tab, you can disable and enable the filter button, background chips, and auto run for the slicer.

Add Interactions

From the Home or Slide ribbon, select Add Interactions or Auto Interact to add interactions between the slicer and the visuals. To add the slicer to multiple slide, you can simply copy and paste it.

  • Click here to learn about interactions.