I have a bunch of dashboards that utilise a parameter [Set latest date] to generate MTD, YTD, prior YTD, prior year MTD, trailing 12 month average etc. E.g. The user can change [Set latest date] to Oct-17 rather than Nov-17 to see the dashboard as at the previous month rather than the latest month.
My current process is when the new (monthly) data is in the .tde, I edit the parameter (Clear All > Add From Field [Month]) to bring in the latest date, however I would like to move away from this manual process.
I could manually add 3 months now, then I would only have to edit the parameter quarterly, however I like how in the current method, the most recent date always appears at the top of the list
Any ideas are much appreciated?
If you can attach a packaged workbook, I should be able to help.
Meanwhile, how are you building your parameter. Have you tried using the "From Field" option? In From Field, use the Date Column from the data source. Hopefully this helps.