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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
sampathK
Microsoft Employee
Microsoft Employee

Change Matrix Column Sub Total Position from Last to First.

Hello Team,

             I have one matrix with some and included Row Sub Total and Column Sub Total. Due large amount in column categorizations end uses every time scrolling left to right for analysis some times this get irritation to them. I want to change column Sub Total right to left second most column in matrix.  Is it poosible to change or any alternative case we have ??

 

Thanks in advance.

 

Regards,

THEASK.

1 ACCEPTED SOLUTION
v-yingjl
Community Support
Community Support

Hi @sampathK ,

 

In Matrix visual format, you can change the Row subtotal position with Top or Bottom in Subtotals menu but you cannot change the Column subtotal position.

Matirx1.pngMatrix2.png

 

Best Regards,

Yingjie Li

 

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

View solution in original post

2 REPLIES 2
Mariusz
Community Champion
Community Champion

Hi @sampathK 

 

As @v-yingjl  mentioned you can not change the subtotal column position, but if you are concerned by users scrolling left/right you can always move Values from columns to rows as per below.

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

v-yingjl
Community Support
Community Support

Hi @sampathK ,

 

In Matrix visual format, you can change the Row subtotal position with Top or Bottom in Subtotals menu but you cannot change the Column subtotal position.

Matirx1.pngMatrix2.png

 

Best Regards,

Yingjie Li

 

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

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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
Top Kudoed Authors