Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Vasudevan
New Member

Bar Chart for Top3 items

Hi,

I need your help to how to plot the bar graph for each "machine" top3 "parts" with "Qty".

Data.png

Thanks.

Vasudevan

1 ACCEPTED SOLUTION

@Vasudevan,

 

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

Sheet1[Errors] > EARLIER ( Sheet1[Errors] )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

9 REPLIES 9
Hardik
Continued Contributor
Continued Contributor

Screenshot_1.pngScreenshot_2.pngBased 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

 

Data1.png

 

Thanks

Vasudevan

Hardik
Continued Contributor
Continued Contributor

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 NicknamePart NumberErrors
A1_16A1271
A1_16B1170
A1_16Z12132
A1_16X7131
A1_16G2130
A2_16D2587
A2_16L1714
A2_16I1813
A2_16J58
A3_16P384
A3_16M567
A3_16N2343
A3_16Q225
B1S729
B1X3228
B1X713
B1C4511
B1G610
C1_18B1107
C1_18P4558
C1_18R1856
C1_18A3647
C2_18B2953
C2_18E649
C2_18F1533
C2_18H7327
C2_18I1822
C3_18J3734
C3_18K9329
C3_18Y3917
D-1B1212
D-1Z46175
D-1G2130
D-1D2598
D-1A191
D-2D25175
D-2P8689
D-2I1875
D-2Q4773
D-2S29866
D-3F31522
D-3C4520
E-1A1322
E-1C264148
E-1A3681
E-1L1781
E-2D25124
E-2Q20953
E-2P8635
E-2E17331
E-3H3121
E-3N2311
F1S757
F1S29850
F1O236
F1T524
G1G2112
G1L3650
G1U8237
Hardik
Continued Contributor
Continued Contributor

Screenshot_4.pngScreenshot_6.pngHey i think this is what you require !! @Vasudevan Please accept the solution

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

@Vasudevan,

 

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

Sheet1[Errors] > EARLIER ( Sheet1[Errors] )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Sam, Can you give the exact DAX formula.

Hardik
Continued Contributor
Continued Contributor

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.