Forum Discussion

Deepaaaa's avatar
Deepaaaa
New Member
1 year ago
Solved

Moving column subtotals which is enabled in visualization pane from right to left (to the front)

Moving column subtotals which is enabled in visualization pane from right to left (to the front) in a matrix visual.

any idea in this 

  • Hi Deepaaaa,

     

    To my knowledge unlike the row subtotals that you can select if they are presented at the top or bottom of the matrix, you cannot move the columns subtotals to the beginning of your values.

     

    One option can be to check the custom visuals, because some of them have more advance options for setting up the matrix layout, be aware some of them are payed and they do not update automatically when a new version of the visual comes out, and sometimes they can break with new power bi updates.

     

    The other option I can for see is for you to have a custom hierarchy for the columns and then using a switch measure to calculate the subtotals and values for each one.

    If you are interested in this option please let me know and I can setup and example for you. 

4 Replies

  • Hi Deepaaaa,

     

    To my knowledge unlike the row subtotals that you can select if they are presented at the top or bottom of the matrix, you cannot move the columns subtotals to the beginning of your values.

     

    One option can be to check the custom visuals, because some of them have more advance options for setting up the matrix layout, be aware some of them are payed and they do not update automatically when a new version of the visual comes out, and sometimes they can break with new power bi updates.

     

    The other option I can for see is for you to have a custom hierarchy for the columns and then using a switch measure to calculate the subtotals and values for each one.

    If you are interested in this option please let me know and I can setup and example for you. 

  • v-aatheeque's avatar
    v-aatheeque
    Icon for Community Support rankCommunity Support

    Hi Deepaaaa 

    I wanted to check if you had the opportunity to review the information provided by MFelix  resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

    Thank you.

    • v-aatheeque's avatar
      v-aatheeque
      Icon for Community Support rankCommunity Support

      Hi Deepaaaa 

      We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.

      If you have any question relating to the current thread, please do let us know and we will try out best to help you.

      • v-aatheeque's avatar
        v-aatheeque
        Icon for Community Support rankCommunity Support

        Hi Deepaaaa 

        Following up to see if the earlier response resolved your concern. Let us know if you need any additional support.