Visualization tab examples
This article gives specific examples of how to configure the visualization tab of the Data Analysis Panel for various types of data visualizations. The visualization tab helps you assign data elements from the underlying metric set to parts of the data visualization. Using the Data Analysis Panel and simple drag-and-drop operations, you can display data in the form of labels, headers, tooltips, colors, etc.
See Setting up the visualization to learn more about the visualization tab.
2. Chart visualizations
2.1. Grouping series in a bar chart
The Series Grouping option of a series allows you determine whether a data point series is grouped into multiple series based on a hierarchy's values.
As an example, consider a metric set with the following data selected and visualized as a bar chart:
- Measures: OrderQty
- Rows: OrderDate hierarchy
Click the Visualization button in the top-right corner of the Data Analysis Panel to switch to the Visualization tab. Under the first series, click More to see additional options. Locate Data Point Label and Series Grouping. Drag the Product hierarchy from the Explore window and drop it under each. The resulting bar chart shows a cluster of bars over each year, each with a bar for each value in the top level of the Product hierarchy.
If there is a series in your chart that repeats the same values in each grouping, you can remove the hierarchy from Series Grouping to prevent it from being displayed multiple times.
Related video: Configuring Metric Sets
2.2. Axis labels
Axis labels can be used to display labels from upper levels of a hierarchy (e.g., Month grouping labels under Day labels) by dragging a hierarchy level from the Explore window, or to display measure values by dragging a measure.
For example, consider the chart below showing typical axis labels displayed for a time dimension hierarchy. They combine the month names with the year repeated in consecutive labels.
To replace this, switch to the Visualization tab in the Data Analysis Panel. Click to expand the Axis section, and remove the time dimension from under Bottom Axis Label.
Find and expand a time dimension hierarchy in the Explore window to list its levels, then click and drag each individual level you want labeled to Bottom Axis Label.
Each level will be displayed as a separate row, and instead of repeating values like the year, each value is displayed once with leader lines grouping the values below. The values are displayed using the short caption format settings in the time dimension.
Add data under Color to apply different colors to data points or series based on their values. Colors are applied according to color rules, which you can configure from the Properties window. See Apply colors to data points or series using color rules for more details.
3. Table visualization
Consider the metric set with data selected as follows:
- Measures: OrderQty, LineTotal
- Rows: OrderDate hierarchy
- Columns: Product hierarchy
Despite terminology such as Columns and Rows, the metric set configuration is not specific to a table visualization. Rather, these metric set terms are describing how data will be selected and grouped into a tabular result, which may then be visualized a variety of ways, including as charts and tables. The figure below shows how this metric set is configured in the Data Analysis Panel, along with the corresponding table visualization.
Click the Visualization button in the top-right corner of the Data Analysis Panel to see the mappings of table elements to metric set elements (measures and hierarchies). In this case, options such as Column Header, Row Header, and Column refer to specific parts of the table visualization. For this particular example, these parts are mapped as follows:
- Column Header - Maps to the Product hierarchy which is displayed as a row of table column headers above the table columns.
- Row Header - Maps to the OrderDate hierarchy which is displayed as a column of table row headers positioned to the left of the table columns. Row headers are a special kind of column designed to visually group data appearing on the right, where cells with the same row hierarchy value are merged. Expanders are used in row headers to allow viewers to click to access the more detailed results making up that row in a lower hierarchy level.
- Column - Maps to the OrderQty and LineTotal measures, each of which is displayed in its own table column. These two columns are repeated for each column hierarchy value (e.g., each Product hierarchy value).
In the above example, table columns are mapped to measures but you can also add hierarchies in order to display a regular column of hierarchy values rather than a row header column.
Each table column has settings such as header text, tooltip, appearance, state styles, and different column types, all of which you can further customize in the Properties window.
When you're setting up interactivity, such as hover-over interactions, you also have the option of targeting a specific table column (e.g., using the Bound visual option).
The Visualization tab also allows you to remove an element of the metric set from the visualization, or to restrict it to only a certain use. For example, a measure can be removed from under Column so that it is not displayed directly in a column of the table, but added instead to the tooltip of some other column.