Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
rc_jharrington
New Member

Custom Date Slicer in Microsoft Fabric Direct Lake

I am using Power BI in direct lake mode against Microsoft Fabric data.  My client would like a report with several slicers on it.  One is a date slicer that they pick start and stop date.  However what they would like it when you first go to the page it would default to start date being yesterday and then the end date being 1 year out.  They also want to be able to select custom date ranges.  Is this possible and how so?  I have googled and watched youtube and not coming across anything that seems feasible given that in Fabric you cannot create Calculated tables.

1 REPLY 1
lbendlin
Super User
Super User

Teach your client how to use the Filter pane.  Use your screen real estate for meaningful visuals rather than wasting it on slicers.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.