Need Help to Sort data for highest sales by supplier for current month

[Anonymous]

Hello,

I havd a table which looks like the fllowing: 

My requirement is to have a bar chart that displays, the top 3 selling vendors for current month based on the sales date (in this case for the month of July, and should change to August when August 21 starts.)

This is what I want to achieve.

Your support is highly appreciated.

Best Regards..

[Icey · Accepted solution]

Hi @Anonymous ,

Try this:

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mohammad_Refaei]

You need to use the visual filter (Sold By) TopN against Sales Amount... since you need top 3 then you should have the seetings as below.

You may download this sample file.

[Anonymous]

Thank you m_refaei. Appreciate your quick response.

But want to have the month dynamically created rather that having a slicer to select the month. 

I was thinking of having a measure using dax to calculate the result. I have no specfic preference though..

My requirement is to have everything in the graph.

Regards.

[Mohammad_Refaei]

Do you mean like having 12 charts for the full year or only the last month?

Or do you mean the chart title?

[Anonymous]

This bar chart is correct, I want my data to b displayed in exactly the same way. 

But here we are get the data for the Month of July based on the value selection in the slicer.

I do not want to have the slicer, the data shuold dynamically be calculated for the month we are in. In this case for July.

[Mohammad_Refaei]

Well... then lets create a new column in your data table:

CurrentMonth =
IF ( MONTH ( TODAY () ) = Data[Month_No], TRUE (), FALSE () )

Add it to the visual filter where it is TRUE.

Please redownload the sample file.

[Anonymous]

Actually that is not working, In this case there will be 2 filters on my report, one for top3 and another one for current month.

First it calculates the top 3 and returns the results which could be for the earlier months and 

then eveluates the filter for Current month, which gives blank result.

[Mohammad_Refaei]

Not really...it will evaluate the Top 3 according to the selected month.

If you want the all time top 3 then we have to write another measure for the YTD sales amount.