cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kevthebandit
Helper II
Helper II

matrix sub total - enable freeze pane ability for all table total

When I switch from using a regular Table viz, to a Matrix Viz, Totals get harder to work with. I still want the Grand Total Numbers for the entire table to be frozen at the top of the Matrix Vizualization. 

 

 

3 REPLIES 3
yingyinr
Community Support
Community Support

Hi @Kevthebandit ,

Whether the problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help other members in the community find the solution easily if they face the similar problem with you. Thank you.

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
yingyinr
Community Support
Community Support

Hi @Kevthebandit ,

You mean the total value is incorrect when switch Table visual to Matrix visual? Could you please provide some sample data and your expected result(exclude sensitive data)? It will help us to make troubleshoting and provide solution. Thank you.

In addition, hope the following blogs can help you resolve the problem.

Making Sense Of Subtotals Settings In The Power BI Matrix Visual

Subtotals and Grand Totals That Add Up “Correctly”

Wrong Totals Using IF and Values() in Power BI

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler
Super User IV
Super User IV

"Freeze Pane", wasn't that a song by the J Giles Band? 🙂

 

Take a look at Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

 

Also MM3TR: https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-...


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors