https://community.fabric.microsoft.com/t5/Report-Server/PowerBI-matrix-show-rowlevels-dynamically/m-p/1163333#M14627 <P>Hello,</P><P>&nbsp;</P><P>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.&nbsp;</P><P>As you can see in the second example, on level 5 (and 6) is the row empty except for the 6th and 7th column.</P><P>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.</P><P>&nbsp;</P><P><img /></P><P><img /></P> Tue, 16 Jun 2020 14:10:22 GMT Anonymous 2020-06-16T14:10:22Z https://community.fabric.microsoft.com/t5/Report-Server/PowerBI-matrix-show-rowlevels-dynamically/m-p/1163333#M14627 <P>Hello,</P><P>&nbsp;</P><P>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.&nbsp;</P><P>As you can see in the second example, on level 5 (and 6) is the row empty except for the 6th and 7th column.</P><P>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.</P><P>&nbsp;</P><P><img /></P><P><img /></P> Tue, 16 Jun 2020 14:10:22 GMT https://community.fabric.microsoft.com/t5/Report-Server/PowerBI-matrix-show-rowlevels-dynamically/m-p/1163333#M14627 Anonymous 2020-06-16T14:10:22Z