Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

PowerBI Matrix make total row always visible

Hello,

 

Is there a way of making the total row of a matrix to be displayed from the begginning, like in the table and not being forced to scroll to the bottom? Thank you.

Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    6 years ago

    Hi Anonymous ,

     

    If you open the Stepped layout, the Total always visible in the bottom.

     

     

    If you close the Stepped layout, the Total will show in the Top, but it cannot visible.

    So you need to create another matrix table, and put it under this matrix table, the result like this.

     

     

    If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

     

    Best regards,

     

    Community Support Team _ zhenbw

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

     

    BTW, pbix as attached.

5 Replies

  • FrankAT's avatar
    FrankAT
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous 

    take a look at the figure:

     

     

    Regards FrankAT

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello FrankAT , I know about this possibility, but I was thinking if maybe there is a way to display the Total row at the bottom of the matrix, but keep it visible all the time. thank you.

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    If you open the Stepped layout, the Total always visible in the bottom.

     

     

    If you close the Stepped layout, the Total will show in the Top, but it cannot visible.

    So you need to create another matrix table, and put it under this matrix table, the result like this.

     

     

    If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

     

    Best regards,

     

    Community Support Team _ zhenbw

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

     

    BTW, pbix as attached.

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    How about the result after you follow the suggestions mentioned in my original post?

    Could you please provide more details or expected result about it If it doesn't meet your requirement?

    If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly.

     

    Best regards,

     

    Community Support Team _ zhenbw

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