Forum Discussion

sublog's avatar
sublog
Icon for Helper III rankHelper III
5 years ago

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

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/idi-p/482763

 

 

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

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

    • sublog's avatar
      sublog
      Icon for Helper III rankHelper III
      5 years ago

      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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.