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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Bokazoit
Post Patron
Post Patron

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
Post Patron
Post Patron

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
Post Patron
Post Patron

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]&"")

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...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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