Manage hierarchies
Last updated
Was this helpful?
Reporting & Writeback Matrix Docs
Last updated
Was this helpful?
Inforiver provides a number of options to manage hierarchies such as expanding or collapsing row/column hierarchies to specified levels, descendants and more.
Currently, in a native Power BI matrix, you cannot expand or collapse columns freely as you can do with rows. With Inforiver, you can expand/collapse specific columns to reveal their children, just as we can do with the row hierarchies in the native Power BI visual.
In this example, the hierarchy in rows is Region -> Sub Region -> Category -> Sub Category.
You can expand/collapse individual rows using the expand/collapse icons. In the image below, you can see that International is fully expanded to the last level, while EMEA and United States remain collapsed.
Inforiver also provides a number of options for expanding/collapsing all branches, expanding/collapsing to a specific level etc. To access these options, mouse over any row, and click on the hamburger menu.
You can perform the following Expand actions.
Expand all items in the rows to reveal the lowest level across all branches.
For example, click on any row and 'Expand all', all the rows till the subcategories will be revealed.
The immediate descendants for the selected level are shown for all the branches.
For example, if you select the row United States and 'Expand Level', the categories will be revealed for all the regions.
All the descendants for the selected row are shown.
For example, if you select the row United States and 'Expand descendants', the categories and subcategories are expanded only for the United States row.
The descendants are expanded to a specific level for all the branches.
For example, if you select the row United States and 'Expand Sub category', the categories and subcategories are expanded for all the regions.
You can also perform the following Collapse actions.
Collapse all items in the rows to reveal only the highest level across all branches.
For example, click on any row and 'Collapse all', only the regions will be shown.
All the descendants for the selected row are hidden.
For example, if you select the row East and 'Collapse descendants', the categories and subcategories are hidden only for the East row.
The descendants are collapsed to a specific level for all the branches.
For example, if you select the row Beverages and 'Collapse Region', the categories and subcategories are hidden for all the regions.
You can add a layer of abstraction to the report by choosing whether to display the child nodes under a hierarchy.
To hide all the child rows contributing to a parent row, click on the row gripper for the parent row and select the 'Hide icon & children for current row' option from the 'Show/Hide Expand icon' section.
The child rows under the 'TV and Video' level have been hidden.
To reinstate the hidden child rows, select the 'Show icon & children for current row' option from the row gripper context menu.
You can also prevent users from expanding and collapsing the hierarchy by hiding the expand icon. This can be achieved by clicking on the row gripper for the parent node and selecting the 'Hide icon for level' option from the 'Show/Hide Expand icon' section.
Notice how the expand icon has been removed for the hierarchy.
To reinstate the icon, select the 'Show icon for level' option from the row gripper context menu.
In this example, the hierarchy in columns is Region -> Sub Region -> Quarter.
To access the other expand/collapse options, mouse over the category names on the top-left of the table (Region, Sub Region, and Quarter), as highlighted.
On clicking the hamburger menu, you can see a list of options.
From this menu, you can perform the following actions:
Expand all the categories in the columns to the lowest level (Quarter) across all branches
Collapse all the categories in the columns to show only the Regions
This option is useful when there are more than 2 hierarchy levels. Here you can expand all branches to Sub Region, for example
In the next section, we'll be creating visual hierarchies using the Group feature.
You can expand/collapse individual columns using the expand/collapse icons . In the image below, you can see that International -> APAC is fully expanded to show the Quarters, while EMEA and United States remain collapsed.
