Slicers versus columns and rows

Contents[Hide]

1. Overview

This article describes the purpose of the slicers, columns, rows, and measures fields of the Data Binding Panel.

The Data Binding Panel appears when you create a new metric set or drag data items onto the dashboard canvas. You can also open this panel from the right-click menu for a data visualization component.

2. Data Binding Panel

The Data Binding Panel lets you build an analytical/OLAP view of your data simply by dragging data items from the EXPLORE window onto its various fields (or axes).

Field / AxisFunctionIs Rendered?
MEASURES Display numeric/fact values Yes
ROWS Display categories/data points Yes
SLICERS Filtering No
COLUMNS Grouping (Series) Yes

The figure below shows the Data Binding Panel for a table visualization on a dashboard.

Data Binding Panel for a table visualization, with fields mapped to visualization axes
Data Binding Panel for a table visualization, with fields mapped to visualization axes

3. MEASURES

One or more measures can be added to the MEASURES field of the Data Binding Panel to display the numeric values you are interested in viewing (such as sales or stock levels). Measure values will be grouped by the row and column hierarchies that have been added, and filtered by slicers, if any.

In a corresponding table visualization, each measure appears once per grouping (e.g. COLUMNS hierarchy member Accessories is a grouping).

Measures displayed using a table visualization
Measures displayed using a table visualization

On a bar chart visualization, additional measures are rendered as different colored bars by default.

Measures displayed using a bar chart visualization (without grouping)
Measures displayed using a bar chart visualization (without grouping)

4. ROWS

One or more hierarchies can be added to the ROWS field of the Data Binding Panel to show more detailed data results (such as sales broken down by country instead of just total sales). You use this field when you want to see a row of data for each hierarchy member value or unique combination of values.

ROWS hierarchy members appear as the row headers of a table visualization.

ROWS hierarchy members in a table visualization
ROWS hierarchy members in a table visualization

On a bar chart visualization, ROWS hierarchy members are displayed along the X axis and correspond to data points.

ROWS hierarchy members in a bar chart visualization
ROWS hierarchy members in a bar chart visualization

5. SLICERS

One or more hierarchies can be added to the SLICERS field of the Data Binding Panel for filtering purposes.

SLICERS hierarchy members are not rendered visually. They are used purely to filter the data values appearing in the visualization. Slicer values also cannot be displayed within tooltips.

In the example below, click the click to add link in the SLICERS field.

Click to add a slicer hierarchy
Click to add a slicer hierarchy

You'll see a list of hierarchies that are available to be added as a slicer. Scroll down and select the Country hierarchy.

List of hierarchies to choose from
List of hierarchies to choose from

The Country hierarchy is added to the SLICERS field.

Next, click the Edit icon to the right of the Country hierarchy. This opens the Configure Metric Set Element dialog.

Click the Default Parameter Value dropdown list and select a hierarchy member value (e.g. Canada) to filter by. Then click Submit.

Select a hierarchy member to filter by
Select a hierarchy member to filter by

The table visualization is now filtered to show measure values corresponding to the selected Country member instead of all countries.

Table shows figures for 'Canada' SLICERS hierarchy member
Table shows figures for 'Canada' SLICERS hierarchy member

6. COLUMNS

One or more hierarchies can be added to the COLUMNS field of the Data Binding Panel for grouping purposes. You use this field when you want to see a column of data for each hierarchy member value or unique combination of values.

COLUMNS hierarchy members appear as the column headers of a table visualization.

Each column within a grouping represents a series of data points.

COLUMNS hierarchy members in a table visualization
COLUMNS hierarchy members in a table visualization

On a bar chart visualization, each COLUMNS hierarchy member corresponds to a series of data points (bars), where each series is colored differently by default.

COLUMNS hierarchy members in a bar chart visualization. There are 4 series, each corresponding to a hierarchy member
COLUMNS hierarchy members in a bar chart visualization. There are 4 series, each corresponding to a hierarchy member

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