Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
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 2
XL DataSource with summary tasks and subtasks
Thnaks for your Help. THis could also concern Finance managers.
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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 79 | |
| 38 | |
| 31 | |
| 27 | |
| 27 |