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

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

Reply
Anonymous
Not applicable

Need to Hide empty names in matrix with non linear hierarchies

Hi folks,

I have prepare a power BI file to show projects cost phasing. Nevertheless some items are on depth 3 (Niveau CBS) especially at the end but most of taks are on dept 2. So the hierchy is not spread at the same level of detail for each phase. Therefore there is  in my Matrix a lot of empty item. There are only 2 item with a depth 3.
Is there a way to hide lines in a Matrix when there is no name (and no need because no  specific data)) ?

I tried hierarchies and the result is the same when Depth is 2. Everything is fine when depth is 3.
need to hide empty line with no level 2need to hide empty line with no level 2XL DataSource with summary tasks and subtasksXL DataSource with summary tasks and subtasks
Thnaks for your Help. THis could also concern Finance managers. 

1 REPLY 1
Hariharan_R
Solution Sage
Solution Sage

Hi,

 

  There is an another thread with similar issue. Please check. You also can use your 4th column in your first table as !=1 in the matrix filter. Just a thought by seeing your screenshots.

 

Solved: Hide a row in a hierarchy if it is BLANk - Microsoft Power BI Community

 

Thanks

Hari

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

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.