We are using a 4-level hierarchy in a Matrix visual:
Level 1: Functional Area (e.g., Revenue, Selling & Marketing, Cost of Sales)
Level 2: Subgroup 2
Level 3: Subgroup 1
Level 4: Partner Farea
Problem Description
The hierarchy is ragged (uneven depth):
Some Level 1 categories (e.g., Revenue) do not have child levels
Others (e.g., Selling & Marketing) expand fully down to Level 4
When users expand the matrix hierarchy, Power BI expands all nodes to the deepest level (Level 4)
As a result:
Categories like Revenue show blank rows for Levels 2, 3, and 4
This creates unnecessary blank entries in the visual
Expectation / Requirement
We want to prevent blank rows from appearing when:
A hierarchy branch does not extend to deeper levels (the plus icon should ideally not be present next to items that have no children or should not expand)
(e.g., Revenue should remain at Level 1 and not expand into empty Levels 2–4)
But currently due to product limitations, this is not possible.
Suggestion -
1. Custom depth setting for each row in a matrix or option to stop any hierarchy at the last non blank value/category.
2. Currently we have a feature to select specific columns, a similar feature is needed to select specific rows.
on:
Tasks and Notes Pane in Power BI Desktop with Jira...