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.
Hi,
I need your help to how to plot the bar graph for each "machine" top3 "parts" with "Qty".
Thanks.
Vasudevan
Solved! Go to Solution.
Correct the DAX formula and apply filter on [Rank].
Sheet1[Errors] > EARLIER ( Sheet1[Errors] )
Based on your data ,i created a table and after that applied the visual level filter on parts column by quantity.Hope this helps.Fell free to reach out for further doubts
Hi Hardik,
Thanks for the help. But i am having the issue that not all the machines shows the top 3 failures. Some are empty & some are showing 1 or 2 data's only. Any clue
Thanks
Vasudevan
do the machines have that data for failures ?Can you share your data file to understand the problem more accurately
Hi, I am attaching the data table.
Machine Nickname | Part Number | Errors |
A1_16 | A1 | 271 |
A1_16 | B1 | 170 |
A1_16 | Z12 | 132 |
A1_16 | X7 | 131 |
A1_16 | G2 | 130 |
A2_16 | D25 | 87 |
A2_16 | L17 | 14 |
A2_16 | I18 | 13 |
A2_16 | J5 | 8 |
A3_16 | P3 | 84 |
A3_16 | M5 | 67 |
A3_16 | N23 | 43 |
A3_16 | Q2 | 25 |
B1 | S7 | 29 |
B1 | X32 | 28 |
B1 | X7 | 13 |
B1 | C45 | 11 |
B1 | G6 | 10 |
C1_18 | B1 | 107 |
C1_18 | P45 | 58 |
C1_18 | R18 | 56 |
C1_18 | A36 | 47 |
C2_18 | B29 | 53 |
C2_18 | E6 | 49 |
C2_18 | F15 | 33 |
C2_18 | H73 | 27 |
C2_18 | I18 | 22 |
C3_18 | J37 | 34 |
C3_18 | K93 | 29 |
C3_18 | Y39 | 17 |
D-1 | B1 | 212 |
D-1 | Z46 | 175 |
D-1 | G2 | 130 |
D-1 | D25 | 98 |
D-1 | A1 | 91 |
D-2 | D25 | 175 |
D-2 | P86 | 89 |
D-2 | I18 | 75 |
D-2 | Q47 | 73 |
D-2 | S298 | 66 |
D-3 | F315 | 22 |
D-3 | C45 | 20 |
E-1 | A1 | 322 |
E-1 | C264 | 148 |
E-1 | A36 | 81 |
E-1 | L17 | 81 |
E-2 | D25 | 124 |
E-2 | Q209 | 53 |
E-2 | P86 | 35 |
E-2 | E173 | 31 |
E-3 | H3 | 121 |
E-3 | N23 | 11 |
F1 | S7 | 57 |
F1 | S298 | 50 |
F1 | O2 | 36 |
F1 | T5 | 24 |
G1 | G2 | 112 |
G1 | L36 | 50 |
G1 | U82 | 37 |
Hardik, I have tried this formula. Could not able to get the desired results. I am attaching the file. Plz help https://drive.google.com/open?id=1J7LrFl93-0bH7PsbFLuiWVMntorbzeJs
Correct the DAX formula and apply filter on [Rank].
Sheet1[Errors] > EARLIER ( Sheet1[Errors] )
Hi Sam, Can you give the exact DAX formula.
https://community.powerbi.com/t5/Desktop/Measure-for-Sum-of-Top-N-items-per-category/td-p/197477
Hope this article helps.Create a new column
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 |
---|---|
105 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |