Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |