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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors