Forum Discussion
Remove empty hirearchy levels
Hi JP_Helsinki,
The design pattern you're looking for is a ragged hierarchy, and Power BI doesn't support it natively. It can be managed with a number of additional modelaling changes and some measures to check which level of the hierarchy a value is on.
The following articles are my go-tos whenever I need to implement such a pattern, and should help you out:
- SQLBI: Parent-Child Hierarchies
- Kasper on BI: Use IsInScope to get the right hierarchy level in DAX
- RADACAD: Removing Blanks from Organizational Ragged Hierarchy in Power BI Matrix Visual
Good luck 🙂
Daniel
Hi JP_Helsinki,
The design pattern you're looking for is a ragged hierarchy, and Power BI doesn't support it natively. It can be managed with a number of additional modelaling changes and some measures to check which level of the hierarchy a value is on.
The following articles are my go-tos whenever I need to implement such a pattern, and should help you out:
- SQLBI: Parent-Child Hierarchies
- Kasper on BI: Use IsInScope to get the right hierarchy level in DAX
- RADACAD: Removing Blanks from Organizational Ragged Hierarchy in Power BI Matrix Visual
Good luck 🙂
Daniel