Forum Discussion
Solved
Bar Chart for Top3 items
Hi, I need your help to how to plot the bar graph for each "machine" top3 "parts" with "Qty". Thanks. Vasudevan
Correct the DAX formula and apply filter on [Rank].
Sheet1[Errors] > EARLIER ( Sheet1[Errors] )
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
Continued Contributor
Continued Contributorhttps://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