Forum Discussion

New Member

8 years ago

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

v-chuncz-msft
8 years ago
Vasudevan,

Correct the DAX formula and apply filter on [Rank].

Sheet1[Errors] > EARLIER ( Sheet1[Errors] )

Icon for Continued Contributor rank

Continued Contributor

8 years ago

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

New Member

8 years ago

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

Icon for Continued Contributor rank

Continued Contributor

8 years ago

do the machines have that data for failures ?Can you share your data file to understand the problem more accurately

New Member

8 years ago

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
8 years ago
Hey i think this is what you require !! Vasudevan Please accept the solution