Forum Discussion
Visualisation or pivot table by groups of data
Super UserThere are more than one options to achieve this in powerbi. I would suggest you to post sample data and expected outcome.
Thank you for this answer.
My complete table looks like below:
| Country | Region | Zone | Dealer | SalesVolume |
| France | 4 | 1 | 1001 | 1 |
| France | 4 | 2 | 1002 | 8 |
| France | 4 | 3 | 1003 | 14 |
| France | 1 | 4 | 1004 | 1 |
| France | 1 | 5 | 1005 | 5 |
| France | 1 | 6 | 1006 | 3 |
| France | 1 | 7 | 1007 | 19 |
| France | 2 | 8 | 1008 | 3 |
| France | 2 | 9 | 1009 | 1 |
My aim is to give the possibility to each region to filter as below, and toy with the information so that it can always have a look at the National Total, the Regional Total, etc. :
| Somme de SalesVolume | |
| Total Region 1 | 28 |
| 1004 | 1 |
| 1005 | 5 |
| 1006 | 3 |
| 1007 | 19 |
| Total Region 2 | 4 |
| Total Region 4 | 23 |
| Total France | 55 |
or develop
| Somme de SalesVolume | |
| Total Region 1 | 28 |
| 1004 | 1 |
| 1005 | 5 |
| 1006 | 3 |
| 1007 | 19 |
| Total Region 2 | 4 |
| 1008 | 3 |
| 1009 | 1 |
| Total Region 4 | 23 |
| 1001 | 1 |
| 1002 | 8 |
| 1003 | 14 |
| Total France | 55 |
I don't know if it is clear :-)
Thanks!
No one?
v-huizhn-msftMicrosoft Employee
Hi Noob78,
For one thing, please create a measure using the following formula. Then create a matrix in PowerBI desktop. Select the Region, Dealer as Row level, Measure1 as value level. You will get the result below.
Measure1 = SUM(Table4[SalesVolume])
For another, if you create same measure, create a pivot table, select the Region and Dealer as Row level, the measure as Values, you will get the expected better result as follows.
Best Regards,
AngeliaThank you! Shall try and let you know :smileyvery-happy:
I can easily obtain the first screenshot of PowerBi.
However, does the second screenshot not come from Excel? Indeed, I wish to have exactly this visualization, but in Power Bi (I mean, collapsible, etc.).
Correct me if I did not get something right :-/