Forum Discussion
Visualisation or pivot table by groups of data
Microsoft EmployeeHi 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:
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 :-/
- v-huizhn-msft
Hi Noob78.
The secondshot is a pivot table. First import the data into power pivot model, create a measure as follows.
Then create a pivot table, when you select the Dealer after Region field in Rows level, the Dealer is subcategory automatically. For example, there several Dealer values for Region1. While in Power BI desktop, it display as the first screenshot. And we can’t set the custom subtotal.
Best Regards,
AngeliaThe visual result is not exactly as I wished, however I note that there are no additional solution for the time being.
Thank you!
Regards
- v-huizhn-msft
Hi Noob78,
I reproduce your scenario on my local computer, I will post the update if I find new solution.
Best Regards,
Angelia