Normal behavior for a stepped matrix with more rows than currently displayed is to show the grand total as a floating row at the bottom. However, when stepped layout is turned off, so is this grand total, regardless of subtotal and per row subtotal settings. Here are screenshots showing the current behaviour (pardon the heavy redaction). The ideal behaviour would be to continue showing the grand total even in non-stepped layout. All row subtotals are enabled in both screenshots. Using version 2.60.5169.4101.
12 Comments
Hi LukeWalker,
I'm not able to reproduce the issue in Power BI desktop version 2.60.5169.4101 64-bit (July 2018). Please download the report and test on your side to see if it works.
Best Regards,
Qiuyun Yu- Status changed:NewtoNeeds Info
Hi v-qiuyu-msft,
This behavior occurs when the matrix overflows the visual bounds and a scroll bar appears. If you set the visual height to 360 px, notice the row grand total dissappears in non-stepped mode. When stepped mode is re-enabled, the grand total reappears.
Regards,
Luke
Hi LukeWalker,
After change the visual height in my sample report to 360, turn off the stepped layout for row headers, when we scroll down to the bottom of the matrix visual, the grand total row is still here. Please update your Power BI desktop to August version 2.61.5192.541 then test again.
Best Regards,
Qiuyun YuHi v-qiuyu-msft,
I do see the grand total when I scroll down to the bottom currently. However the difference is that in stepped view, the total is floating (i.e., it displays even when I'm not scrolled to the bottom). In non-stepped view, as you pointed out, you need to scroll to the bottom to display the total. I'd think this behaviour should be consistent across matrix layouts.
Regards,
Luke
I agree with LukeWalker here. Only being able to see the grand totals at the bottom of a whole data set isn't helpful. If there are thousands of lines, it can take a long time to scroll all the way down... Being able to see the grand total, fixed to the bottom of the frame, like with the way it works with stepped rows, is much more helpful.
Agree. This needs to be an option or default behaviour. This is one of those little annoyances/limitations with the matrix view that would significantly improve usability if addressed.
