Add a slicer comparison


1. Overview

This walkthrough shows you how to add a slicer comparison, which lets you apply different filter values to a measure and compare the results together.

2. Walkthrough

A slicer comparison measure can be added if you have numeric data (a measure) and a slicer to filter it by.

This example starts with a new metric set, but the same steps can be followed when editing a metric set checked out to you on a dashboard or another view.

2.1. Create a metric set

From the main menu, click New and then Metric Set.

Choose a data source containing numeric data to use as a measure.

In our example, we chose a data cube containing the measure OrderQty, then dragged an extra time dimension hierarchy OrderDate from the Explore window to Rows (adding a hierarchy other than to Slicers is not necessary for a slicer comparison). After re-visualizing to a bar chart in the toolbar, this displays a bar for each year.

Bar chart showing annual data
Bar chart showing annual data

2.2. Add a slicer

Add a hierarchy under Slicers. In this example we dragged the Product hierarchy under Slicers.

Add a slicer
Add a slicer

A slicer allows you to filter the measure values without changing how the data is grouped into rows, columns, or data points. You can choose to filter your slicer, but in this example we will leave its filter value as the default setting All.

2.3. Add a slicer comparison

The slicer comparison adds a 'parallel' version of the measure that's displayed alongside the original but can be filtered differently.

In the toolbar, click Add Slicer Comparison. This can be found under Data Tools if you are editing a view such as a dashboard.

Add a slicer comparison
Add a slicer comparison

In the Slicer Comparison dialog, confirm the Measure and Slicer Hierarchy that you want to use (in our example there is only one of each).

Select a measure and hierarchy to create the slicer measure
Select a measure and hierarchy to create the slicer measure

Specify the filtering Default Parameter Value for the slicer comparison. In this example, the orders are filtered by Accessories and Bikes.

Specify default parameter value
Specify default parameter value

Optionally provide a Parallel Slicer Measure Name, or leave it blank to generate one automatically, then click the Submit button at the bottom of the dialog.

A new slicer measure is added to the metric set and can be seen in the Data Analysis Panel. The visualization is updated to show the newly added slicer measure for comparison.

Updated visualization
Updated visualization

In this example, the slicer comparison allowed us to easily compare the order quantity for Accessories and Bikes (in orange) against the total order quantity for all products (in blue) for each year.

3. Add a filter to change while viewing

The Default Parameter Value specified above can be changed while viewing the metric set on a dashboard or another view by adding a filter and connecting it to this parallel slicer parameter.

If you are editing the metric set on a dashboard when you add the slicer comparison, you can use the Automatically Add Parameter Control option in the dialog as a shortcut.

Add a hierarchy Value filter and connect it to the slicer measure (disconnect it from other parameters, such as the original slicer hierarchy ProductID in this example).

Connect filter to the parallel slicer
Connect filter to the parallel slicer

4. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri