show two totals in matrix

[razieh1990]

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:

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:

[Anonymous · Accepted solution]

Hi @razieh1990 ,

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

First, transform your data like this:

Then, create matrix visual by step:

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

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]

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

My condolences.