Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
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
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
User | Count |
---|---|
100 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |