You seem to have a week filter in your filters shelf there, please could you right click, and select edit filter to show me what's in there?
If you're selecting specific weeks, then it'll only tick on the selected ones. If new weeks are added on, the additional weeks are not automatically selected.
Thanks for your reply!
If you look at the right side of the picture attached, you will see the Filter and the Weeks selected. Even though Weeks 24 and 25 are selected in the filter, they do not appear in the viz.
It's as if the sheets are stuck even though the filters aren't blocking the data from appearing in the viz.
I think this is by design. Instead of specifying the exact weeks in your filter, try to come up with a formula that automatically pulls in weeks based on the date. Something similar to building a calculated column like this:
if INT(REPLACE([Week], "W", "")) <= datepart('week',today())) then TRUE else FALSE END
The first part pulls the week number from your Week column and converts it to a number. Then the second part pulls week number from today's date. Then filter on TRUE and when you refresh it will show weeks 1 to today's week number. Is this what you mean?