Slicer issues on date/ year / week

Hi all, I struggling to get my data to show the year and weeks correctly.
I have pinned it down to the fact that I have grouped the year and months and this is giving me an end date, so once past this the weeks will not populate correctly.

Is there a way of getting past this?
I'm hoping this is what is messing with the doughnut charts as that not pulling data after week 2.

I have attached the sheets , Data is pulled from sheet1 (Access connection).

Thanks

Sometimes a pivot table will recognize a date field and auto group it into financial quarters, months, or years. When this occurs an easy fix is to ungroup those date fields. Grouping the data by weeks can be more challenging and the pivot table might not do it automatically. A work around might be to add columns to your source data for the months and weeks to label each row as it should be grouped in the pivot table. This can be done manually or by using the month() year() or day() functions