Filtering Time-Based Line Graph via Top 10 for a Given Month

[Anonymous]

I have created a dashboard that shows the overall top 10 customers based on net sales and a line graph that shows the past 13 months for those top 10 customers. The customer would like to be able to select a particular month (say February 2018) and have the line graph update to show the history for the top 10 customers of February 2018. 

I do not think there is a way to resolve this in a single visual/page, but I also cannot think of a way to resolve via any method other than to just manually select the customers on a separate page. Does anyone have any thoughts on the best way to proceed?

[Anonymous]

@Anonymous,

In your scenario, you may need to create a new table containing the data of Top 10 users in each month, then create a new line chart using the data in the new table. 

If you have any questions, please share sample data of your table and provide dax you use.

Regards,
Lydia

[Anonymous]

@Anonymous - 

I created a sample file and PBIX in a Google drive folder to share:

https://drive.google.com/open?id=15VBBeneWtf7KGDhmdoXPTy12-WEiQQyH

I am not sure how you would setup the filter to draw from the right top 10 table assuming you mean you would create a top 10 table for each month (with the right historical data in there). Appreciate the help and advice!

Brian