Move Total from Matrix Table to the top instead of the bottom

[user365576]

Hello everyone,

I am trying to move the Totals of my Matrix table to the top instead of the bottom that they appear. 

I tried to do it from the visual format and the Row subtotals settings, but the position is greyed out and i cannot change it.

Any idea how can it be resolved?

[EduardD]

if you use recent Power BI desktop version change matrix style to outline, then you will be able to adjust it.

[Anonymous · Accepted solution]

@MFelix Thanks for your contribution on this thread.

Hi @user365576 ,

You can follow the steps below to achieve it:

1. Upgrade the version of your Power BI Desktop to the latest one(Version: 2.130.930.0 64-bit (June 2024))

Download Microsoft Power BI Desktop from Official Microsoft Download Center

2. Open the pbix file using the latest version of Power BI Desktop

3. Select the matrix visual and navigate to Format pane. Find the tab "Layout and style presets" and choose the option "Outline" as layout type

Best Regards

[dawoud04]

Hi @Anonymous 

I've tried this solution using PowerBI desktop May 2024 and it worked, however when I upload the file to my report server (May 2024), the total appears at the bottom?

[user365576]

Thank you so much, it worked!

[MFelix]

Hi @user365576 ,

You are at the correct setting try to turn off the Per Row Level and see if it makes it active,

Not sure in what version you are on but on previous versions when there were updates of visualizations and you opened an PBIX file created on previous version the new options would not be available because the new visual was not "selected" that could be seen by the fact that the visualization was not highlithed on the visualization selection pane, just click on it again to see if it assumes the new features.

If this does not work try to recreate you matrix and see if the option is still turn off or not.