Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
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
Thanks a lot!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |