Enable an option for a hierarchy to expand upward instead of downward
M
Mikael Iuel-Brockdorff
Description:
By default, Power BI expands hierarchies downward, meaning that aggregation or parent members appear above their corresponding leaf members when expanding levels.
Please make an option in the configuration to reverse the hierarchy expansion direction, so that when a hierarchy is expanded, the aggregation members appear below their corresponding leaf members.
Configuration Options:
Default Behavior (Downward):
Aggregation members appear above child (leaf) members — matches Power BI default.
Reversed Behavior (Upward):
Aggregation members appear below their corresponding leaf members when expanded.
Implementation Details:
Visual Configuration Setting:
Add a new property in the visual configuration panel:
Hierarchy Expansion Direction → Options:
Downward (Default)
Upward (Aggregation below leaf)
Context Menu Option:
Add a right-click menu item when expanding a hierarchy level:
Expand Upward
Expand Downward
This allows users to control the expansion direction interactively per visual or per session.
Persistence:
The selected expansion direction (either from the configuration panel or via right-click action) must be saved in the “Save State”, ensuring that reopening the report or reloading the visual retains the user’s preferred expansion mode.