Date Slicer with default values on From Date and To Date

[erikbeauch]

Hi everyone, I checked many posts, tried various options, including unsuccessul attempts with ChatGPT so far. It seems like a common requirement, but not supported out of the box by Power BI. Thanks in advance for any help you can provide.
Requirements:

• The Transaction table has a column named AuthorizationDate
• Need to add a single Date Slicer visual with the Between style  (not two slicers with a reset button)
• From Date: by default, should be a month earlier than the To Date
• To Date: by default, should be the latest date from the Transaction table
• Custom selection: the user must be able to pick up any other date in the From and To fields. Therefore the visual cannot be restricted by a relative date filter.
• Refresh: when accessing the report, the From Date and To Date must be refreshed with the default values.

It seems like this requires quite a custom solution. Any hint? Can't believe trying to replicate this basic feature available on SSRS would involve so much head scratching on Power BI! Thanks

[Fowmy]

@erikbeauch 

I did a video some time back, pleas check it out: https://www.youtube.com/watch?v=KBEsPGxDxHM&pp=ygUWZGVmYXVsdCBkYXRlIGV4Y2VsZm9ydA%3D%3D

[erikbeauch]

Thanks @Fowmy, the video is really well done. This is getting close to the requirements, but not entirely since it involves another filter than the Date Slicer and some resetting by the user. In the current use case, the goal is that the unique Date slicer will be used for user interactions. So it needs at all time to reflect the data range currently beeing displayed, instead of toggling between two slicers.