Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 1 | Defect Level 2 | Supplier | Defect Qty |
A1 | A | Apple | 1 |
A1 | A | Apple | 1 |
A2 | A | Apple | 1 |
A3 | A | Apple | 1 |
A4 | A | Apple | 1 |
B0 | B | Apple | 1 |
B1 | B | Apple | 1 |
B1 | B | Apple | 1 |
B2 | B | Orange | 1 |
B0 | B | Orange | 1 |
C1 | C | Orange | 1 |
C2 | C | Orange | 1 |
C1 | C | Orange | 1 |
C0 | C | Orange | 1 |
C1 | C | Orange | 1 |
A1 | A | Orange | 1 |
C2 | C | Pineapple | 1 |
B3 | B | Pineapple | 1 |
B2 | B | Pineapple | 1 |
B0 | B | Pineapple | 1 |
C1 | C | Pineapple | 1 |
C2 | C | Pineapple | 1 |
You can use "drill down combo" or "drill down combo pro" of zoom charts from get more visuals.
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.
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!
User | Count |
---|---|
94 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
115 | |
106 | |
85 | |
65 | |
64 |