Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Moving column subtotals which is enabled in visualization pane from right to left (to the front) in a matrix visual.
any idea in this
Solved! Go to Solution.
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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
Hi @Deepaaaa
Following up to see if the earlier response resolved your concern. Let us know if you need any additional support.
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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsAdvance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.