The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
User | Count |
---|---|
3 | |
2 | |
2 | |
2 | |
1 |
User | Count |
---|---|
7 | |
4 | |
4 | |
3 | |
2 |