Slicers are used to filter data visualizations in data discoveries, presentations, and tabulations. 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)

Creating Slicers

You create slicers using the Add New Slicer icon in the menu to the left of the worksheet:

Clicking this displays the New Slicer dialog:

Choose the Model you wish to create the slicer from, then expand the required data group and select the required item (in this case – Manufacturer):

If the hierarchy is from a different model, use Cross Model Mapping to define the relationship between the model used by the data in Tabulate and the slicer's model.A new slicer is created and displayed at the top of the worksheet:

Select different values from the drop-down to view different slices of data. To change the slicer settings, click on the menu (red box) on the right hand side of the slicer, and select settings (blue box).To change the format, select format (green box), and click remove (orange box) to remove the slicer from the Tabulation

Note: Tabulate populates the rows and columns based on the query, so the number of rows and columns is determined by the original query. By applying slicers certain rows and columns might result in a null. The number of rows and columns will not be reduced as a result of inserting a slicer

Other topics