Forum Discussion

Vasudevan's avatar
Vasudevan
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

Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Vasudevan,

     

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

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

9 Replies

  • Hardik's avatar
    Hardik
    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 

    • Vasudevan's avatar
      Vasudevan
      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

      • Hardik's avatar
        Hardik
        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