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.
• The slicer cannot be filtered on the Filter pane
• Refresh: when accessing the report, the From Date and To Date must be refreshed with the default values.

An alternative to a Between Date Slicer can be two individual date fields (From and To) if the same behavior can be achieved.

Any hint on how to achieve this? Thought that this basic feature in SSRS would be easy to replicate on Power BI, but apparently not! Thanks

[Anonymous]

Hi @erikbeauch ,

I tried to reproduce some of the requirements you need.

I create a table and a calculated column.

Table = CALENDAR(DATE(2023,1,1),TODAY())

column = 
VAR _1 =
    TODAY () - 1
RETURN
    IF ( ( 'Table'[Date] ) <= _1, 1, BLANK () )

Next you can create a new measure and put it into Filter pane.

Measure = 
VAR _1 =
    TODAY () - 1
RETURN
    IF ( MAX ( 'Table'[Date] ) <= _1, 1, BLANK () )

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[erikbeauch]

Hi @Anonymous thanks for the suggestion. It would be acceptable if the users would clearly know to open the Filters pane and change the values there, but they are not savvy at all on this front and me must reproduce the SSRS version. So as a requirement, the slicer cannot be filtered, even from the pane. It's really about setting default values, without being limited to those in the selection.

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