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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
pasit
Frequent Visitor

Matrix and hierarchy problem

Hi,
 
I'm working with Power BI report and I have problem to remove blank rows from matrix .. I have product hierarchy that is inconsistent. 
 
Hierarchy goes for example so that
 
- Main product
          - Component
          - Sub product 1
                    - Component 3
          - Sub product 2
                    - Component 1
                              - Sub component 1
                                        - Sub component 6
                   - Component 2
 
And so on .. there can be 7 level in hierarchy
In the matrix are 10 different measures, like sales, last year sales, coming sales, gross margin ... 
 
I'm not able to provide sample data more closely, but is there any easy way to hide blank rows from the matrix because although measures does not return any calculated data hierarchy is always shown to the lowest level .. and if I try to filter data from some empty hierarchy level, it removes all rows from the matrix that level even there would be some data ... this is very confusing. The requirement is to use matrix, but is there any other way to show this kind of hierarchcal data .. treemap is not good choise
 
Pasi
1 REPLY 1
lbendlin
Super User
Super User

I'm not able to provide sample data

We can't help you if you cannot provide meaningful sample data.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.