Forum Discussion

Frequent Visitor

9 years ago

Visualisation or pivot table by groups of data

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

Icon for Super User rank

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?
  - v-huizhn-msft
    Microsoft Employee
    9 years ago
    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