Forum Discussion

karimkz's avatar
karimkz
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Please help with correct table for this hierarchy

Hello. I'm kinda new to PowerBI, though watched ~90 vids.  I want to create a drilling down pie chart. Table is attached.   So this is a couple of trucks (Type) which can work or do nothing (d...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi karimkz,

     

    In your scenario, you need to transform data in Query Editor firstly. Please select loading, hauling,repair and dinner columns then click Unpivot Columns button, then get format like below:

     

     

    Go to the report, create a pie chart visual like below:

     

     

    Drill down feature can't change chart type, so when press hauling slice, it will also use pit chart visual to display cat and hitachi values. Please check attached .pbix file.

     

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi karimkz,

 

In your scenario, you need to transform data in Query Editor firstly. Please select loading, hauling,repair and dinner columns then click Unpivot Columns button, then get format like below:

 

 

Go to the report, create a pie chart visual like below:

 

 

Drill down feature can't change chart type, so when press hauling slice, it will also use pit chart visual to display cat and hitachi values. Please check attached .pbix file.

 

 

Best Regards,
Qiuyun Yu

  • karimkz's avatar
    karimkz
    Icon for Advocate I rankAdvocate I
    9 years ago

    Thanks a lot!