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