Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
Solved! Go to 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.
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.
@razieh1990 You have fallen into Custom Matrix Hierarchy territory. The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community
My condolences.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |