Stepped Layout turned off in Matrix visual view removes column totals?

[sublog]

I have 3 fields in Rows, and I have expanded to see all 3 fields on the left of the visual. All of my grand totals in the measures section go away as soon as I toggle Stepped Layout off. Is there a way to show the three fields expanded out with the column value totals visible? I've tried a lot of different settings and it can't get it to work. 

I also saw this in my search, but I don't even see the totals if I scroll to the bottom of the scroll bar. 

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

[Anonymous]

Hi @sublog 

I think your problem is that when you turned off the  Stepped layout in your Matrix, the grand total is not floating and you need to scroll to the end to display it.

I reproduced your problem.

Turn on stepped layout:                                                           Turn off stepped layout:

Currently, Power BI doesn't support you to show floating grand total when you turn off stepped layout in matrix visual.  You can build a card visual with sum function to show the grand total in it.

Your demand is a good idea, while it is not supported to implement in Power BI currently.
You can vote up this idea for this function：Microsoft Idea  · Always display the total of non-stepped matrix (powerbi.com)
Or you can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,

Rico Zhou

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

[amitchandak]

@sublog , You should able to see total after scroll, Check if grand total/sub total property is on?

[sublog]

@amitchandak you are right. For me to see the totals at the bottom I have to turn on row subtotals and then turn on the select the per row-level and turn off the 2nd dimension so I don't have duplicating totals after every row. Then I still have to scroll all the way to the bottom of a page with thousands of rows. Seems pretty stupid that it doesn't show you the floating totals at the bottom

[amitchandak]

@sublog , I think there should some idea for floating total in case of the stepped layout.

Please check and vote or log new one https://ideas.powerbi.com/ideas/