Slicers versus columns and rows
1. Overview
This article describes the purpose of slicers, columns, rows, and measures in theData Analysis Panel.
The Data Analysis Panel appears when you drag and drop data onto a metric set, or the canvas of a dashboard or other view. If closed, you can re-open it from the toolbar or 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.
Type | Purpose | Visible |
---|---|---|
Measures | Display numeric/fact values | Yes |
Rows | Group by values into rows/data points | Yes |
Slicers | Filtering only | Limited |
Columns | Group by values into columns/series | Yes |
The figure below shows the Data Analysis Panel for a table visualization.
![Data Analysis Panel for a table visualization](http://m.merkalis.com/support/images/dbi/docs/design/databind-panel-v3.png)
3. Measures
Add data underMeasuresin 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 into the Rows and Columns data that have been added, and filtered by Slicers, if any.
In a table visualization, each measure appears as a column. When selecting measures together with data underColumns, the measure columns will reoccur for each column hierarchy value (as seen underAccessoriesandBikesbelow).
![Measures displayed for each product category in a table](http://m.merkalis.com/support/images/dbi/docs/design/databind-measures-v3.png)
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)](http://m.merkalis.com/support/images/dbi/docs/design/databind-measures-chart-v3.png)
4. Rows
Data can be added underRows数据分析小组,组b的措施y these values into rows, such as sales broken down by year instead of just a single total sales value.
This data often consists of text or date/time values, and is called a hierarchy (or dimension) in Dundas BI.
![Row hierarchy members in a table visualization](http://m.merkalis.com/support/images/dbi/docs/design/databind-rows-v3.png)
If you add multiple hierarchies, a row will be displayed for each combination of their values in the data, for example for each year and for each country.
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](http://m.merkalis.com/support/images/dbi/docs/design/databind-rows-chart-v3.png)
5. Slicers
Data can be added underSlicersin the Data Analysis Panel when you only want to filter by those values. In our example shown below, all the data displayed in the table is filtered to only online orders by filtering a column of true/false values namedOnlineOrderFlagto the valueTrue.
The slicer values selected for filtering can be displayed in tooltips and labels, which will be the same for the entire visualization. If you want to display different values in each row, column, or data point, you can add this data elsewhere on the metric set instead of Slicers.
After adding data under Slicers, click its filter icon and choose the values to filter by.
![Select hierarchy members to filter by](http://m.merkalis.com/support/images/dbi/docs/design/databind-slicers-filter.png)
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
Data can be added underColumns数据分析小组,组b的措施y the selected values into columns.
This is similar to Rows, but since measures are normally each displayed as a column, measures will be repeated for each column hierarchy value.
Column hierarchy members appear as another row of column headers in a table visualization.
![Column hierarchy members in a table visualization](http://m.merkalis.com/support/images/dbi/docs/design/databind-columns-v3.png)
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](http://m.merkalis.com/support/images/dbi/docs/design/databind-columns-chart-v3.png)