Slicers versus columns and rows
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 / Axis||Function||Is Rendered?|
|MEASURES||Display numeric/fact values||Yes|
|ROWS||Display categories/data points||Yes|
The figure below shows the Data Binding Panel for a table visualization on a dashboard.
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).
On a bar chart visualization, additional measures are rendered as different colored bars by default.
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.
On a bar chart visualization, ROWS hierarchy members are displayed along the X axis and correspond to data points.
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.
You'll see a list of hierarchies that are available to be added as a slicer. Scroll down and select the Country hierarchy.
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.
The table visualization is now filtered to show measure values corresponding to the selected Country member instead of all countries.
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.
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.
7. See also
- Video: Creating and Viewing Dashboards
- Video: Creating and Using Filters on a Dashboard
- Create a metric set and add a filter
- Understanding the Dundas BI data model