Skip to main content

Power BI

Planned

Dynamic Date Slicer (improve relative date slicer)

Vote (2742) Share
's profile image

on 18 May 2017 19:35:34

This is a repost of my idea that was closed as completed, but the 'relative date slicer doesn't allow any of the described request hence my idea is not implemented....

The new date slicer is awesome, but it would be so nice if you could set a dynamic date selection instead of a static. With a static filter the user will always have to set the dates before the saved report makes sense - especially as the report gets older.

Dynamic options could be
YTD, QTD, MTD, WTD, Today, This Year, This Quarter, This Month, This Week and so on.

original idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17004565-dynamic-date-slicer

Administrator on 16 Jun 2017 23:57:11

The relative date slicer (a Preview feature as of June '17) gets us close to this with the 'This Month' or 'This Year' settings. That is a dynamic date selection that updates based on the current system date. We plan to add a 'YTD'/'MTD' option to specifically select a range from the start of the month/year up to today, hopefully that'll address the remaining requirements!

Comments (115)
's profile image Profile Picture

Damon on 05 Jul 2020 23:38:41

RE: Dynamic Date Slicer (improve relative date slicer)

Looking to be able to set the begin and end dates of a Between date slicer with column or measure values.

's profile image Profile Picture

Cherie on 05 Jul 2020 23:36:07

RE: Dynamic Date Slicer (improve relative date slicer)

I am not sure if this will affect the relative date filter or not but if so, please add an AND/OR option to the relative date filter. This comes up all the time with my users. They want to see 8 weeks in the past and all future dates for an order file as an example. They use the relative date a lot on graphs for dashboards where you want to see where we have been at the same time where we are going which we are currently not able to do with a relative date filter.

's profile image Profile Picture

David Anstee on 05 Jul 2020 23:35:58

RE: Dynamic Date Slicer (improve relative date slicer)

I would like to see relative Date Filters based on Quarter, e.g. This Quarter, Last X Quarters, Next Quarter, Next X Quarters etc.

's profile image Profile Picture

Christopher Wright on 05 Jul 2020 23:35:28

RE: Dynamic Date Slicer (improve relative date slicer)

I'd like to be able to filter for quarters, including:
This quarter (QTD)
Last # quarters
QTD plus previous # quarters

's profile image Profile Picture

Stuart on 05 Jul 2020 23:35:07

RE: Dynamic Date Slicer (improve relative date slicer)

Would also be great to be able to select historical and future dates at the same time.

would be useful when looking at overdue items and items about to become overdue.

's profile image Profile Picture

MB on 05 Jul 2020 23:34:23

RE: Dynamic Date Slicer (improve relative date slicer)

Please allow the option for the end-user to also select an anchor date. We have use cases where user might want to see performance of 2 prior quarters to say Mar 31st ... if the date filter is of relative type - there is no way the end-use can do that. Besides adding YTD/MTD, etc. please also let the end-user select the anchor date (just as a report author can right now).

's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:34:10

RE: Dynamic Date Slicer (improve relative date slicer)

I'd like to be able to filter for quarters, including:
This quarter (QTD)
Last # quarters
QTD plus previous # quarters

's profile image Profile Picture

Chris99 on 05 Jul 2020 23:34:02

RE: Dynamic Date Slicer (improve relative date slicer)

Can you also add support for fiscal date slicing? This is pretty fundamental in the corporate world.

's profile image Profile Picture

A Geraci on 05 Jul 2020 23:32:54

RE: Dynamic Date Slicer (improve relative date slicer)

Need to be able to change the start of the week to any start date.

's profile image Profile Picture

Ismael Texidor on 05 Jul 2020 23:31:07

RE: Dynamic Date Slicer (improve relative date slicer)

Is there a way to start from the first of the month when selecting "Last" in the relative date slicer instead of the same day as today?

Example:
Today is SEP 16, 2018
Selection = "Last 1 Year"
Desired output = Dates start from "Sep 1, 2017" instead of "Sep 16, 2017".