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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
razieh1990
Helper I
Helper I

show two totals in matrix

Hello

I created a matrix whose column is cities (A, B, C,) and the rows are the list of stations ( AA, BB, CC), and the value is the sale amount per city and station.

I want to add another value: the total sale quantity per station for all cities in the matrix.

so the matrix looks like this visualized below:

 

razieh1990_0-1696944994780.png

 

What I want :

I want to show the sale Amount per city and satation but I want to only display the "total sale quantity " and "total sale amount"per station and all cities instead of sale quantity per city and station .

below matrix I want to create , and need your advise how to create it in power bi:

 

razieh1990_1-1696945141249.png

 



1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @razieh1990 ,

 

Based on your description, I made a simple test to achieve your goal.

First, transform your data like this:

vtianyichmsft_3-1697093689778.png

 

Then, create matrix visual by step:

vtianyichmsft_4-1697093689783.png

 

Power BI Desktop does not support hiding columns in the matrix. However, we can wrap it:

vtianyichmsft_7-1697093780059.png

 

Perhaps this will work, and if you have any questions, please provide me with more information to make sure we can better solve the problem for you!

 

An attachment for your reference. Hope it helps.

 

Best regards,
Community Support Team_ Scott Chang

 

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
Anonymous
Not applicable

Hi @razieh1990 ,

 

Based on your description, I made a simple test to achieve your goal.

First, transform your data like this:

vtianyichmsft_3-1697093689778.png

 

Then, create matrix visual by step:

vtianyichmsft_4-1697093689783.png

 

Power BI Desktop does not support hiding columns in the matrix. However, we can wrap it:

vtianyichmsft_7-1697093780059.png

 

Perhaps this will work, and if you have any questions, please provide me with more information to make sure we can better solve the problem for you!

 

An attachment for your reference. Hope it helps.

 

Best regards,
Community Support Team_ Scott Chang

 

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

Greg_Deckler
Community Champion
Community Champion

@razieh1990 You have fallen into Custom Matrix Hierarchy territory. The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community

 

My condolences.



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...

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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