Please help with correct table for this hierarchy

[karimkz]

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 (delay). 

Loading and Hauling extends Work; Repair and Dinner extends Delay. 

I want to see total distribution of Work hours and Delay hours, then pressing on Work I want to see what kind of work takes more time and then pressing on Hauling I want to see info on each Truck type. 

First, how do I sum up work hours and delay hours? If I put its column in Values then it can only Count it. 

Thanks a lot!

[v-qiuyu-msft · Accepted solution]

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]

Thanks a lot!