Forum Discussion

Noob78's avatar
Noob78
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...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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

Noob78's avatar
Noob78
Frequent Visitor
9 years ago

v-huizhn-msft

The 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's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Noob78,

    I reproduce your scenario on my local computer, I will post the update if I find new solution. 

    Best Regards,
    Angelia