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

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
Anonymous
Not applicable

How to change position of subtotals?

As you can see, in this matrix, the drilldown for change the position of row subtotals is enable... but in other reports, the same drilldown is disable. Suggestions? It's a setting or anything else?

AndreaCBS_0-1727948342941.png

The dropdown in the red box, is the posittion (top and bottom)

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Thanks for @Ritaf1983 's reply.
Hi @Anonymous ,

Please check that the following settings are enabled for Matrix Visuals.

It will cause the row subtotal to be unable to change position.

vdengllimsft_0-1728267026938.png

vdengllimsft_1-1728267102674.png

 

Best Regards,
Dengliang 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

4 REPLIES 4
Anonymous
Not applicable

Hi @Anonymous ,

May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster .
Thank you very much for your kind cooperation!

Best Regards,
Dengliang Li

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

Anonymous
Not applicable

Thanks for @Ritaf1983 's reply.
Hi @Anonymous ,

Please check that the following settings are enabled for Matrix Visuals.

It will cause the row subtotal to be unable to change position.

vdengllimsft_0-1728267026938.png

vdengllimsft_1-1728267102674.png

 

Best Regards,
Dengliang Li

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

Ritaf1983
Super User
Super User

Hi @Anonymous 

Can you show the desired result?

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Anonymous
Not applicable

As I said I have few report with that dropdown in greay/disable. So I wanna know the setting to do that.

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.