Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
karimkz
Advocate I
Advocate I

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.powerbi.jpg

 

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!

 

1 ACCEPTED SOLUTION
v-qiuyu-msft
Community Support
Community Support

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:

 

q3 - Copy.PNG

 

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

 

q6.PNG

 

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.

 

q5.PNG

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-qiuyu-msft
Community Support
Community Support

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:

 

q3 - Copy.PNG

 

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

 

q6.PNG

 

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.

 

q5.PNG

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks a lot! 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.