Skip to main content

Power BI

Needs Votes

Relative Date Slicer allows selection of start and end dates.

Vote (28) Share
's profile image

on 22 Dec 2017 07:54:55

The Relative Date Slicer is nice and works very well. I've been using it since it was released for preview. However I would love if it could behave like the date slicer where I could pick any random start and end values once the report is loaded. Sometimes you need to dig through the data and see its behavior in different time periods, but you also want the report to be loaded to the latest "week" or "month" like the relative date slicer allows. My idea would be to allow the slicer to have a default relative date like "last Month" and have the same bar from the date slicer under the widget that would allow you to move the start and end dates of your data. This would allow data investigations from previous dates that not always end in Today's date and would keep the feature of having your report up to date when loading it for the first time. It would also be nice if the slider were to move through the selected dates window when dragging it around. In other words, if I select last 2 weeks I would like for the slider to move the start and end dates while keeping 2 weeks of data in between them (of course if I decide to move only the start or the end dates it should override the previous behavior and give me a custom date range that might not be equal to 2 weeks)

Comments (3)
's profile image Profile Picture

Nick Taylor on 10 Mar 2023 16:57:39

RE: Relative Date Slicer allows selection of start and end dates.

Yes, why can't the user toggle between relative date and actual date range. Currently a developer can toggle, but he or she needs to actually edit the Power BI report.

's profile image Profile Picture

Sinead Jones on 23 Nov 2021 15:00:22

RE: Relative Date Slicer allows selection of start and end dates.

This is really needed

's profile image Profile Picture

Brandon on 05 Jul 2020 23:17:31

RE: Relative Date Slicer allows selection of start and end dates.

Yes, I have reports that refresh automatically and it would make life much easier to have the date move automatically.