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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.