Default a "Between" Date Slicer to Yesterday on load, while allowing users to pick custom date

[Venkatesh_]

Hi everyone,

I’m trying to solve a user experience challenge with a Date Slicer in Power BI.

My Goal:
Every time a user opens or refreshes the report, I want the standard "Between" date slider handles to dynamically snap and default to Yesterday's date (as the end-date boundary, or as a specific starting window).

The Catch:
I cannot just use a relative date filter or basic visual-level filtering (like setting a column filter to IsYesterday = 1). Doing that completely clips the calendar table and locks the users out, preventing them from dragging the sliders backward to access historical dates or future dates.

Power BI natively hardcodes whatever dates are selected when the .pbix file is published.

Has anyone successfully cracked this workaround for a true "Between" slider? I am open to using either a clean DAX measure trick or a specific UI/overlay layout.

Ideally, the solution should:

1. Always load showing Yesterday's date on first open.
2. Keep the entire historical and future calendar range fully open/scrollable if a user wants to manually change the slider.

Appreciate any code snippets, layout design tricks, or workaround patterns you can share! Thanks in advance!

[parry2k]

@Venkatesh_ I was waiting for the Jun 2026 Power BI update to be released officially. It has a new date picker, see if this can help you get what you are looking for:Power BI June 2026 Feature Summary - Microsoft Fabric Community

[grazitti_sapna]

Hi @Venkatesh_ ,

I came accross the same hurdle where user wanted to show only current month's data whenever the report is opened.

To achieve this i added a new column in date table with values current month, then created a new date filter and added filter from current month column not to be blank.

I added a button on top to navigate between two separate bookmarks which says "custom date" and "Current month" and created two bookmark pages.

So if the user is on current month bookmark view they can click on button "Custom date" and select the date as per their requirement and they want to switch to current month view, they can click on "Current month" button added on custom date page.

You can also achieve the same, just disable the date selection (Add a toggle button) when user want to see yesterday's data they can switch the toggle.

Make sure while publishing Current view is active so that only current page when user opens the report. 

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together! 

[Venkatesh_]

@grazitti_sapna 

That’s a great suggestion. I’ve already implemented two bookmarks as you recommended:

• “Special Date” – provides options like Last 7 Days, Last Month, and Current Month
• “Custom Date” – allows users to select specific dates using a between slicer

However, the issue arises when users switch to Custom Date. The slicer defaults to the full available range, starting from 2024. As a result, users have to scroll extensively to reach the most recent dates, which creates a poor user experience.

This is the main pain point I’m trying to address from a usability perspective.

Thanks again for your suggestion—it definitely helped improve the approach.

[grazitti_sapna]

Hi @Venkatesh_,

To overcome this, I'd created a separate column with current month calculation, and applied a filter on date slicer such that the Current month column is not "blank", this way the date will always filter to current month date range.

Create something like 

Current Month Date =
IF(
YEAR('Table'[Date]) = YEAR(TODAY()) &&
MONTH('Table'[Date]) = MONTH(TODAY()),
'Table'[Date],
BLANK()
)

Then you can apply a filter on date slicer that "Current Month Date" is not blank

and then use this date in your current month view book mark, one thing to consider the Sync should be off on other sheets i.e. date slicer from current page should not sync with custom page and vice versa

[v-menakakota]

Hi  @Venkatesh_  ,
Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank  @grazitti_sapna  and @parry2k , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Best Regards, 
Community Support Team

[v-menakakota]

Hi @Venkatesh_ ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Best Regards, 
Community Support Team

[grazitti_sapna]

@Venkatesh_ also make sure on cutom date range you use your actual date column and in current month date range, date is selected from "Current Month Date" column which you created.

Be sure about sync between both pages, they should not be synced

[parry2k]

@Venkatesh_ you may want to hold off on implementing any complex workaround for now. Based on the Microsoft Fabric roadmap, the upcoming Date Picker enhancement should address this scenario natively.

It might be worth waiting to see if the new functionality meets your requirements before investing time in a custom solution.

Microsoft Fabric Roadmap