cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Matrix -grand total when I scroll down to the bottom invisible

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.

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.

 

is there any resolution for this issue 

https://community.powerbi.com/t5/Issues/Matrix-Non-Stepped-Layout-Removes-Overflow-Grand-Total-Row/i...

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User V
Super User V

Re: Matrix -grand total when I scroll down to the bottom invisible

Hi @PowerBITesting

 

Go to the subtotals on the matrix options and search for the subtotals llocation and choose top. By default is on bottom. 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





View solution in original post

3 REPLIES 3
Highlighted
Super User V
Super User V

Re: Matrix -grand total when I scroll down to the bottom invisible

Hi @PowerBITesting ,

 

There is no update on this, the only way that I see as a workaround is to make the subtotals on top instead of the bottom (but for me that is not the best option I prefer my subtotals on the bottom).

 

Another work around is to create another table showing only the totals and turn off total on the primary table then group both of them(also not a perfect workaround).

 

Hopefully, they will change this in future versions.

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





Highlighted
Helper III
Helper III

Re: Matrix -grand total when I scroll down to the bottom invisible

How I can show subtotals on top?

Highlighted
Super User V
Super User V

Re: Matrix -grand total when I scroll down to the bottom invisible

Hi @PowerBITesting

 

Go to the subtotals on the matrix options and search for the subtotals llocation and choose top. By default is on bottom. 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors