Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |