Expand and collapse hierarchy members
This article shows you how to use the Expand and Collapse functionality to see more detailed breakdowns or step back to a summary view.
Examples are shown for tables, charts, and treemaps, and the same functionality is available for relationship diagrams including the tree diagram.
2. Expand and collapse
Expanding a member is similar to performing a Drill Down in-place, without filtering out other members. In the same manner, collapsing a member is similar to performing a Drill Up in-place.
These options are available when selecting data using a multi-level hierarchy, or when multiple hierarchies are selected in the Data Analysis Panel.
All of the chart types support the Expand/Collapse option, which is available when you right-click (context menu) a data point.
For example, switch to View mode, right-click the Bikes member in this pie/sunburst chart, and then select Expand.
The chart now shows an exploded view of that member but the other members are not filtered out. They are still displayed in order to provide context.
You can continue expanding members, or collapse members using the Collapse option.
Charts can also display expander buttons similar to those in tables when there is a categorical axis displayed.
Expand and collapse works similarly for a treemap visualization. Just right-click a treemap node and select Expand.
The Bikes node is expanded while leaving the other nodes unchanged.
Right-click the Road Bikes node and click Expand to further expand that node into the next hierarchy level. Or, click Collapse to go back to the original view.
Table visualizations support expand and collapse functionality through the use of expander buttons (triangles) in row header and column header cells. These are toggle buttons that can be used to expand or collapse. Alternatively, you can right-click a cell and use Expand or Collapse from the context menu.
If you have a table visualization that displays multiple row hierarchies, and one of the row hierarchies is single-level, you'll still see expander buttons in the corresponding column, as long as the row hierarchy is not the last one. These expander buttons allow you to collapse the other corresponding hierarchy members even though they belong to a separate hierarchy.
If you don't want this functionality, you can disable it (that is, don't show expanders for collapsing one hierarchy into another) by going to the table's Properties. Under the HEADERS section, uncheck the Allow Collapsing Separate Hierarchies property.
3. Expand/collapse on click
If you want to be able to simply click on data to expand or collapse it, you can easily set up this interaction for any visualization that supports expanding and collapsing.
When editing, choose Set Up Interactions in the toolbar, and choose Expand / Collapse.
In the dialog that appears, you typically don't need to change any settings, and you can click the Submit button at the bottom to confirm.
Choose View in the toolbar, and click a data point. If there is data in a hierarchy or level below, it will be expanded; otherwise, it will be collapsed into the hierarchy or level above.
4. Collapse all
Every hierarchy has an All or Grand total value above the first level of the hierarchy. You can use the Collapse All option of the context menu to collapse all of the values of the hierarchy you clicked all the way to this level. This can be used to leave out the details of that hierarchy and view the data broken down only by other hierarchy values.
When editing, you can also set a hierarchy to be collapsed this way initially, as follows:
From the Data Analysis Panel, edit the hierarchy.
Tick the Collapse All checkbox.
Click Submit. The ProductID hierarchy in the visualization will now be initially collapsed to the All value. You or viewers can use the Expand All option from the context menu to view the first level of the hierarchy.
- Expanding and collapsing requires the Change Data privilege. This can be disabled for users or groups, on the dashboard or other view, or on the visualization.
- The Collapse All option may cause a pie chart to disappear if Hide Grand Total is selected in the chart properties. You will still be able to use Expand All from the context menu.
- Unknown indicates data outside of the hierarchy. This is not a member of the hierarchy and cannot be expanded. You can see data under Unknown by selecting an additional hierarchy or by changing the hierarchy level.
- Filters applied to the standard hierarchy will be ignored on the expanded members. The filtering will still be maintained on the aggregated hierarchy levels.