Forum Discussion
meiwah
Resolver I
2 years agoPower BI Visual Matrix - Column Grand Total to Stick
Hi, My matrix is wide. I need to scroll a lot right to view the column Grand Total. Is there any way like to make the grand total stick within view so that I don't need to scroll. Thanks! ...
AnalyticsWizard
Solution Supplier
2 years agoHi meiwah!
To make the Grand Total in your Power BI matrix stick within view, follow these steps:
Row Subtotal Position: Change the setting for Row Subtotal Position to Top. This will ensure that the grand total remains visible even when you scroll down. You can find this option under the Paintbrush settings of the matrix visual 1.
Stepped Layout: Note that this solution works best when using a stepped layout. If you’re not already using this layout, consider adjusting it to achieve the desired behavior 1.
Here’s how you can achieve this:
- Set Row Subtotal Position to Top.
- Use a stepped layout for optimal results.
- meiwah2 years ago
Resolver I
Thanks AnalyticsWizard! But it is for Row Grand Total. Is there a way for Column Grand Total