cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
york
Helper I
Helper I

Pareto Chart with multiple level

Hi Guys:

   I have raw data like below, I want to create a pareto chart with below data, and the X axis is the Defect level 1 and defect level 2, I hope the two level can be drilled, and the Y axis is the qty of the defect, I tried but my chart can't be drilled, could you tell me how to make it?

Defect Level 1Defect Level 2SupplierDefect Qty
A1AApple1
A1AApple1
A2AApple1
A3AApple1
A4AApple1
B0BApple1
B1BApple1
B1BApple1
B2BOrange1
B0BOrange1
C1COrange1
C2COrange1
C1COrange1
C0COrange1
C1COrange1
A1AOrange1
C2CPineapple1
B3BPineapple1
B2BPineapple1
B0BPineapple1
C1CPineapple1
C2CPineapple1
3 REPLIES 3
Dhairya
Solution Supplier
Solution Supplier

You can use "drill down combo" or "drill down combo pro" of zoom charts from get more visuals.

Dhairya_0-1685355880300.png

Please mark my solution as accepted if it helped you!

Hi Dhairya:

   Thanks for your reply, and I think the chart can meet our requirements, I may need to create some measures to create the pareto chart.

Dhairya
Solution Supplier
Solution Supplier

yes you have to create mesures as per requirements and plot them in required heirarchy.

Please mark my solution as accepted if it helped you!
Thank you!


Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors