Sravanthi_B , Yes, we have that issue, unless you create  This Week as a static value. And when that is selected, you have to use a card visual to display range. 

example Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA 

Hi Sravanthi_B ,

I see you're dealing with a slicer that doesn't automatically update to show the latest week when new data comes in. This is actually pretty common with Power BI slicers.

Here's what you can do to fix this:

Quick Fix - Use Relative Date Filter: Right-click your week slicer and switch to "Relative date filtering." Set it to "Last 1 weeks" or "This week." This way it'll always show the current/latest week without manual updates.

DAX Solution: Create a calculated column to mark your latest week:

IsLatestWeek = 
IF([WeekEndDate] = MAX(Table[WeekEndDate]), "Yes", "No")

Then filter your visuals to only show "Yes" values.

Auto-Select with Bookmarks: Since you're already using bookmarks, you could automate this with Power Automate flows that update your published reports when new data arrives.

Default Filter Approach: Set up a page-level filter that always shows the maximum week range. Go to Filters pane, drag your week field, and set it to show only the latest week.

The relative date filter is probably your easiest bet since it handles the automation without any extra setup.

Check out Microsoft's guide on time-based filtering for more options.

Hope this helps get your slicer updating automatically!

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

This response was assisted by AI for translation and formatting purposes.

Hi Sravanthi_B 

Just checking in to see if the responses shared by the burakkaragoz amitchandak helped resolve the issue with the week slicer not auto-selecting the latest range when new data (e.g., 14 Jul – 20 Jul 2025) is added.

Since you mentioned currently managing this via bookmarks, we wanted to confirm if the suggested approaches worked for your scenario, or if you're still facing challenges.

Please feel free to share any updates or if you need further assistance we’re happy to help!

Sravanthi_B Hey,

Create a measure as below and add it to visual filter set value = 1.

Measure = IF(SELECTEDVALUE(Data[meeting_process_date]) = MAXX(FILTER(ALLSELECTED('Calendar'),'Calendar'[WeekSlicerDates]=TRUE()),'Calendar'[WeekStart]),1,0)

Kindly refer below solution which have similer requirement like yours- Solved: Week slicer to default to latest week - Microsoft Fabric Community

Thanks

Harish KM

If above step's solved your problem. Kudos will be highly apprieciated. Accept this as solution as well