Values in the filter columns not refreshed


How do we make the values under filters get updated along with the dataset refresh?
For example, I put Report Week in the filter, but the dataset only has trailing 6 weeks data. Ideally, in the filter list, I should only see 6 numbers which will be dynamic since last 6 weeks numbers will change each week.
However, for now, it’s always showing all the week numbers which are 1 to 52.
I tried to include the “Relevant values in the filter” based on below post, still seeing all the historical week numbers in the filter list.
Is there any other way to solve this issue?

Hi @danddong -It is currently not possible to automatically update filter values along with dataset refresh in QuickSight. The filter values are independent of the underlying dataset. As a workaround, you could try creating a calculated field in the dataset that returns the last 6 week numbers based on the current date. Then apply filter on this calculated field instead of the original date field. This would require recalculating the field on every dataset refresh though.

At AWS, our roadmap is primarily driven by our customers. Your feedback helps us build a better service. I have tagged this as a feature request.