Using the checkbox list filter control

Contents[Hide]

1. Overview

A checkbox list filter control allows multiple value selection from a hierarchy dimension or slicer. Only the first level of the hierarchy is visible in the checkbox list dialog.

2. Prerequisites

You need to be using a hierarchy from an SSAS Cube, or in the case of relational data, you need a hierarchy created from the Hierarchy designer.

Data used in this sample is based on the Data Cube created from the article Using a data cube to join tables.

3. Setting up the Checkbox List control

  1. From the data cube, drop the measure OrderQty and the hierarchy to the dashboard.
  2. From the data cube, drop the dimension FirstName to the ROWS section of the Data Binding Panel.
  3. From the data cube, drop the hierarchy ProductHierarchy to the SLICERS section of the Data Binding Panel.

    Data Binding Panel
    Data Binding Panel

  4. From the toolbar, add a checkbox List filter control.

    Add a checkbox list filter
    Add a checkbox list filter

  5. Bind the filter to your hierarchy. You might need to uncheck any default selection to expose the hierarchy slicer.

    Bind the filter to your hierarchy
    Bind the filter to your hierarchy

4. Testing

Select Bikes and Clothing on the checkbox list filter. (Product Category level).

Checkbox list filter allows you to select multiple values from the first level
Checkbox list filter allows you to select multiple values from the first level

5. Result

Result
Result

6. Properties

    • Hide Token Menu: If this is set to true, the token menu will not be displayed on the parameter control.

      Checkbox list with token menu hidden
      Checkbox list with token menu hidden

    • Manual Items: If enabled, the item(s) displayed in the control are manually controlled instead of auto-populated from any associated View Parameters. This is most useful when using this control with script instead of with a parameter. This is not applicable if the checkbox list control is bound to a hierarchy, like in this sample.
    • Single Selection Mode: If enabled, the checkbox list will allow only single selection.

7. 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: 7am-6pm, ET, Mon-Fri