Add a slicer comparison
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.
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.
2.2. Add a slicer
Add a hierarchy under Slicers. In this example we dragged the Product hierarchy under Slicers.
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.
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).
Specify the filtering Default Parameter Value for the slicer comparison. In this example, the orders are filtered by Accessories and Bikes.
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.
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.
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).