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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
San_Raz
Frequent Visitor

Remove Blank rows from a Hierarchy in a matrix table.

I am having a table where there are heirarchical parental levels to the Name column.

 

Level 1level 2Level 3Level 4Name
A1B1  Activity 1
A1B2C1D1Activity 2
A2B3C2 Activity 3
A3   Activty 4


When I create a matrix table, some of the parent levels of the name columns are blank. But the matrix table doesnt recognize this and creating a blank rows for each levels as shown below.

San_Raz_0-1738684186163.png

I wanted to remove the blank rows and only display the levels where there is a value as displayed below

San_Raz_1-1738684315210.png

 



1 REPLY 1
lbendlin
Super User
Super User

While it is possible to prune dead branches with custom visuals  you seem to want to collapse branches with dead parents. That is not currently possible in any visual, and it will most likely result in user confusion anyway.  Better cleanup your data.  There should be no blank parent elements in any hierarchy.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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