Hi people!I am new on the forum and think you guys are making amazing job helping us noobs.Thanks in advance!As the subject says, I have a data visualisation issue:I would need a table in which I can see in turns: only the total results of a country / the total results of each zone slicing the country / the details of each entity.It is the simplest action in Excel: grouping rows and developing the group at envy.In powerby I don't have the trick!Please help!

There 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:CountryRegionZoneDealerSalesVolumeFrance4110011France4210028France43100314France1410041France1510055France1610063France17100719France2810083France2910091 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 SalesVolumeTotal Region 128100411005510063100719Total Region 24Total Region 423Total France55 or develop Somme de SalesVolumeTotal Region 128100411005510063100719Total Region 241008310091Total Region 4231001110028100314Total France55 I don't know if it is clear :-) Thanks!

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,Angelia

Thank you! Shall try and let you know :smileyvery-happy: v-huizhn-msftI 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 :-/

Visualisation or pivot table by groups of data

9 Replies

BhaveshPatel
Super User
9 years ago
There are more than one options to achieve this in powerbi. I would suggest you to post sample data and expected outcome.
- Noob78
  Frequent Visitor
  9 years ago
  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!
  - Noob78
    Frequent Visitor
    9 years ago
    No one?

Forum Discussion

Visualisation or pivot table by groups of data

9 Replies

Related content

Pivot issue

Pivot / Unpivot?

Fabric & Azure Data User Group Program Requirements & Benefits

Pivot or Group

Community User Group Experience

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

	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