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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Bokazoit
Responsive Resident
Responsive Resident

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
Responsive Resident
Responsive Resident

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
Responsive Resident
Responsive Resident

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

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

Power BI Monthly Update - August 2025

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