Using a slider filter


1. Overview

This article shows you how to use a slider filter to select a single or a range of numeric values.

2. Filtering a numeric range

For this example, create a new dashboard using the Blank template.

Drag a measure (SafetyStockLevel) and a row hierarchy (Name) from the [Production].[Product] table in Explore.

Create a dashboard with a table visualization
Create a dashboard with a table visualization

Click Filter in the toolbar, and then select Slider (found under More).

Add a Slider filter
Add a Slider filter

The Filter Visualizations panel for the slider filter shows that it is already connected to the SafetyStockLevel measure.

Filter Visualizations panel
Filter Visualizations panel

The Slider filter supports selecting a range of numeric values, which is why it shows two slider handles in this scenario. The minimum and maximum values of this numeric range need to be set next (unless the defaults of 0 and 100 are appropriate for your data). 

Go to Properties for the slider filter, and for example:

  • Set Value (First) to 0 - This is the first slider (handle) value.
  • Set Value (Second) to 1000 - This is the second slider value (if slider is in range mode).
  • Set Value Maximum to 1000 - This is the maximum value of the slider.

Slider filter properties
Slider filter properties

Switch to View mode from the toolbar and start using the slider. Hover over the range portion of the slider to see the current first and second slider values displayed in a tooltip.

Slider filter tooltip in View mode
Slider filter tooltip in View mode

3. Filtering a single numeric value

To change the previous example to a single-valued slider, the easiest way is to go to the Properties window for the slider and delete the Value (Second) item.

Delete the second slider value
Delete the second slider value

Another approach is to start from the beginning and add a Single Number filter first. This will automatically give you an associated view parameter (viewParameter 1) that supports a single value. Next, delete the Single Number filter but say no when it asks if you want to delete associated view parameters. Add a Slider filter. In the Filter Visualizations panel, click Parameters in the top-right and connect to viewParameter 1 instead.

4. Properties

The following are some additional properties available to customize in the Properties window:

4.1. Show Min / Max Labels

Under Look Properties, use the Show Min / Max Labels property to display the minimum and maximum slider values as labels.

Show min / max value labels
Show min / max value labels

4.2. Vertical Layout

Under Layout Properties, use the Vertical Layout property to orient the slider filter vertically instead of horizontally.

5. See also

Dundas Data Visualization, Inc.
400-15 Gervais Drive
Toronto, ON, Canada
M3C 1Y8

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