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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Blank Spaces in a balance sheet hierarchy Matrix

This is a 5-level balance sheet hierarchy and it works perfectly if the 5 levels are used. The problem is when I only have 3 or 4 levels of data. I get a blank row because I have blanks in the empty cells for the 4-5 level. I would like to know if there is a way to stop the dropdown before the blank cell. I am attaching a screenshot of the matrix. Screenshot (31)_LI.jpg

 

Thanks for the help!

1 ACCEPTED SOLUTION
DataInsights
Super User
Super User

@Anonymous,

 

See the link below:

 

https://www.daxpatterns.com/parent-child-hierarchies/ 





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

Proud to be a Super User!




View solution in original post

1 REPLY 1
DataInsights
Super User
Super User

@Anonymous,

 

See the link below:

 

https://www.daxpatterns.com/parent-child-hierarchies/ 





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

Proud to be a Super User!




Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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