Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
JP_Helsinki
Frequent Visitor

Remove empty hirearchy levels

HI! Im trying to build a custom Matrix from a table, so that the empty hierarchy levels do not display. 

 

Category 1Category 2Category 3Value
BMWBlackNew1
BMWWhite 2
AudiRedUsed2

 

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!

1 ACCEPTED SOLUTION
dm-p
Super User
Super User

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





Did I answer your question? Mark my post as a solution!

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)




View solution in original post

1 REPLY 1
dm-p
Super User
Super User

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





Did I answer your question? Mark my post as a solution!

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)




Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors