Power BI Visual Matrix - Column Grand Total to Stick

[meiwah]

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!

[v-rongtiep-msft]

Hi @meiwah ,

How to fix the row totals in a matrix is as @AnalyticsWizard ‘s says.

As far as I concerned, Power BI is now unable to achieve what you need . You can vote the  idea at  Column top totals    and wait for users with the same needs as you to vote  to help make it happen as soon as possible.

I ahve also found a similar post, please refer to it to see if it helps you.

Solved: Matrix Column Grand Total - Microsoft Fabric Community

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AnalyticsWizard]

Hi @meiwah!

To make the Grand Total in your Power BI matrix stick within view, follow these steps:

1. 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.

2. 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.

[meiwah]

Thanks AnalyticsWizard! But it is for Row Grand Total. Is there a way for Column Grand Total