Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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!
My course: Introduction to Developing Power BI Visuals
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!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.