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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Bokazoit
Continued Contributor
Continued Contributor

Dynamic Date slicer between default 30 days

Is this possible in some way?

 

I need my date slicer to be dynamic to the user, but also default to show last 30 days like this:

 

day1.jpg

 Above is for today when the user opens the report. below is tomorrow:

 

day2.jpg

 

I have searched the internet without luck.

1 ACCEPTED SOLUTION
Bokazoit
Continued Contributor
Continued Contributor

My solution is to use a relative date slicer and below that a date slicer that reacts / filters to the relative slicer. Not pretty but doable for now

View solution in original post

4 REPLIES 4
Bokazoit
Continued Contributor
Continued Contributor

My solution is to use a relative date slicer and below that a date slicer that reacts / filters to the relative slicer. Not pretty but doable for now

amitchandak
Super User
Super User

@Bokazoit , You can not. The best is that you can use a relative date slicer

 

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

 

or you can create a column like this in your date table and use

Is Last 30 = if('Date'[Date]>=TODAY()-30 && 'Date'[Date]<=TODAY(),"Today",[Date]&"")

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Bokazoit
Continued Contributor
Continued Contributor

That requires the user to always choose relative dates or be active on a specific date!? That is so weird. I can either be using the report on time or not use it. 

 

I have a user group that prefer last 30days but on a non defined day would like to see the development between to different dates and that does the relative not support 😞

 

Really not satisfying. I know You are not to blame but it is a totally normal procedure in a modern company to see a default periode and choose their own! It is even a standard Microsoft functionality on SSRS 😵😠

@Bokazoit , There are a few ideas already there for it. Have a relative date slicer with the date and initialize date.

You can check and vote or log a new one https://ideas.powerbi.com/ideas/

 

also refer if this can help

https://community.powerbi.com/t5/Desktop/Required-custom-date-Slicer-Last-7-days-last-15-days-last-3...

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 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.

Top Solution Authors
Top Kudoed Authors