Latest week update in slicer

[Sravanthi_B]

Hi,

I have a week slicer with ranges like 07 Jul - 13 Jul 2025. When the latest week's data (e.g., 14 Jul - 20 Jul 2025) is added, the slicer in Power BI Desktop does not automatically select the latest week range.

Currently, we are managing this behavior manually by updating bookmarks.

Thanks in advance.

[HarishKM]

@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

[Sravanthi_B]

Hi @HarishKM, I have tried the solution you provided, but it still doesn’t resolve the issue

[HarishKM]

@Sravanthi_B Hey,

1) I will create a new column using below dax 

IsLatestWeek = IF(YEAR(DateTable[Date]) = YEAR(TODAY()) && DateTable[WeekNumber] = WEEKNUM(TODAY(), 2), "Latest Week", "Other Weeks")

2) Use the IsLatestWeek column to create a slicer.

3) By default select "Latest Week" in the slicer, which will filter to show only the dates within the latest week. This ensures users can select "Latest Week" initially but still have the option to explore "Other Weeks."

4) Create bookmarks that capture different states of your slicer (such as one for showing all dates and another for the default "Latest Week").

5) Use buttons in Power BI to toggle between these bookmarks, letting users easily reset to the latest week or explore other data.

Thanks

Harish KM

If these steps help resolve your issue, your acknowledgment would be greatly appreciated.

[Sravanthi_B]

Hi @HarishKM I have previously tried this solution, but it was not accepted.

Here’s the screenshot of the format they want.

[HarishKM]

@Sravanthi_B Hey,
Kindly refer this video - Auto Selected LATEST MONTH in Power BI | Dynamic Auto selection with New Button Slicer in Power BI

Thanks

Harish KM

If these steps help resolve your issue, your acknowledgment would be greatly appreciated.

[v-aatheeque]

Hi @Sravanthi_B 

Just checking in were you able to review the video shared by @HarishKM dynamically auto-selecting the latest month in Power BI using the button slicer?

Has it helped resolve your issue with the week slicer not auto-selecting the latest range?

Please let us know if you need further assistance.
we’ll be happy to guide you further.

[Sravanthi_B]

Hi @v-aatheeque , The solution provided by Harish is based on month, but my scenario involves dates. Additionally, they are not accepting the use of button. They want the default slicer selection to reflect it directly.

[v-aatheeque]

Hi @Sravanthi_B 

To help set up your weekly slicer exactly like you're expecting (e.g., “14 Jul - 20 Jul 2025”), could you please provide a small sample of your data?

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided. 

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

[v-aatheeque]

Hi @Sravanthi_B 

To help us tailor the weekly slicer setup exactly as you're envisioning (e.g., "14 Jul - 20 Jul 2025"), could you please share a small, representative sample of your dataset? This will help us understand your date structure and format the slicer output accordingly.

which include:

• A few rows of your date column

• Any grouping or logic you're currently using (if applicable)

• The exact output you're expecting based on the sample

This will help us move forward with a precise and effective solution. Thanks again!

[v-aatheeque]

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]

@v-aatheequeHi, I am still encountering the same issue. The solutions provided so far do not automatically select the latest week.

[burakkaragoz]

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.

[amitchandak]

@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