Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Deepaaaa
New Member

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 

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

4 REPLIES 4
v-aatheeque
Community Support
Community 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.

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.

Hi @Deepaaaa 

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

MFelix
Super User
Super User

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors