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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

PowerBI matrix show rowlevels dynamically

Hello,

 

I am using a tablematrix in PowerBI with 6 rows and 7 values. I present this in the matrix with a Stepped layout. See the first example. As you can see, there are 5 levels to expand to. Basicly there are 6 but in this example, I show only 5. 

As you can see in the second example, on level 5 (and 6) is the row empty except for the 6th and 7th column.

Is there a possibility within PowerBI to hide this level 5 blank row and show only the subtotals? So when expanding to a next level, show only if there is information on row level. Otherwise, show only the subtotals but in combination with rows that contain information.

 

Example1.JPG

Example2.JPG

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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