Slicers versus columns and rows

Contents[Hide]

1. Overview

This article describes the purpose of slicers, columns, rows, and measures in the Data Analysis Panel.

The data analysis panel appears when you create a new metric set by dragging data onto a metric set or dashboard canvas. You can also open this panel from the context menu for a data visualization.

2. Data Analysis Panel

The data analysis panel lets you build a view of your data simply by dragging data from the EXPLORE window.

TypePurposeVisible
MEASURES Display numeric/fact values Yes
ROWS Group by values into rows/data points Yes
SLICERS Filtering only No
COLUMNS Group by values into columns/series Yes

The figure below shows the data analysis panel for a table visualization on a dashboard.

Data analysis panel for a table visualization
Data analysis panel for a table visualization

3. MEASURES

Add data under MEASURES in the data analysis 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 table visualization, each measure appears as a column. When selecting multiple measures together with a column hierarchy, the measure columns will reoccur for each column hierarchy value (e.g., Accessories).

Measures displayed for each product category in a table
Measures displayed for each product category in a table

In a chart, each measure is displayed as a series of data points, each with a different color by default.

Two measures displayed as a bar chart (without grouping into additional columns/series)
Two measures displayed as a bar chart (without grouping into additional columns/series)

4. ROWS

Hierarchies can be added under ROWS in the data analysis panel to group the measures by the selected values into rows (such as sales broken down by country instead of just a single total sales value). If you add multiple hierarchies, a row will be displayed for each combination of their values in the data.

Row hierarchy members in a table visualization
Row hierarchy members in a table visualization

In a bar chart, rows of data are displayed as data points (bars). These will often be displayed along a chart axis to correspond with each data point.

Row hierarchy members in a bar chart
Row hierarchy members in a bar chart

5. SLICERS

Hierarchies can be added under SLICERS in the data analysis panel when you only want to filter by their values.

Slicer hierarchy members are not displayed anywhere in the visualization (including its tooltips), and only used to filter the other values. If you want to filter by values while also displaying them, you can place them elsewhere on the metric set.

After adding a hierarchy under SLICERS, click its filter icon and choose the values to filter by.

Select hierarchy members to filter by
Select hierarchy members to filter by

In a dashboard or another view, you can also add a filter to your view connected to this slicer, or connected to any other hierarchy or measure.

6. COLUMNS

Hierarchies can be added under COLUMNS in the data analysis panel to group the measures by the selected values into columns. Since measures are normally each displayed as a column, they will be repeated for each column hierarchy value. If you add multiple column hierarchies, the measures will be repeated for each combination of the hierarchy's values in the data.

Column hierarchy members appear as another row of column headers in a table visualization.

Column hierarchy members in a table visualization
Column hierarchy members in a table visualization

In a bar chart, each column hierarchy member splits each series of bars into separate series, where each series is colored differently by default.

Column hierarchy members in a bar chart. There were originally two series, and each has been split into three: one for each hierarchy member
Column hierarchy members in a bar chart. There were originally two series, and each has been split into three: one for each 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