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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
uva0224
Frequent Visitor

PowerBI matrix, sub accounts total over multiple month

Hi PowerBI Experts, 

I need your help on this question. Is here any way to make the PowerBI Matrix display like this table

 

uva0224_0-1680121985338.png

I can't seem to get it display the yellow part? 

My Column has 2 levels, Month and Store are from users' selection.

Row is just 1 level, product is not a selection.

Any suggestion is greatly appreicated.

 

Thank you,

Le

 

4 REPLIES 4
Greg_Deckler
Community Champion
Community Champion

@uva0224 You could potentially do something like this: The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Thank you, but can you show me how to make this 'green' part , I need it at 2 level, not one level.

uva0224_0-1680129847083.png

 

vicky_
Super User
Super User

You need to turn on row subtotals in a matrix visual.

I tried, it only add subtotal for me at the bottom.

Column has 2 levels, 1st Month, 2nd Store. They are selection by user.

Would you be able to share a screen shot of where it is?

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.