Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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..
Solved! Go to 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.
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.
Do you mean like having 12 charts for the full year or only the last month?
Or do you mean the chart title?
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.
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.
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.
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.