Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
HI! Im trying to build a custom Matrix from a table, so that the empty hierarchy levels do not display.
| Category 1 | Category 2 | Category 3 | Value |
| BMW | Black | New | 1 |
| BMW | White | 2 | |
| Audi | Red | Used | 2 |
What Im betting now for the second row is
- BMW-White-BLANK-2
How could I remove the blanks in between from the hierarchies?
Thanks for the help!
Solved! Go to Solution.
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:
Good luck 🙂
Daniel
Proud to be a Super User!
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
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:
Good luck 🙂
Daniel
Proud to be a Super User!
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |