Forum Discussion
Need Help to Sort data for highest sales by supplier for current month
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..
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.
8 Replies
- Mohammad_Refaei
Solution Specialist
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.
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?
- Icey
Community Support
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.
