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 (110)
RE: Dynamic Date Slicer (improve relative date slicer)
Need more functionality for period to date. Businesses like to use 2 fiscal years plus the current FYTD. This is not possible with the current date slicer.
RE: Dynamic Date Slicer (improve relative date slicer)
It will be fantastic if "This" refers to the last date selected by the user on a slicer, not the system date.
RE: Dynamic Date Slicer (improve relative date slicer)
Is the new version planned with a date to select?
RE: Dynamic Date Slicer (improve relative date slicer)
If we add one more feature to Relative Date Slicer, then it would pretty much remove most of the dimension model relative month/year/week offset field. Most of the times we look at reports from 3 months past to 3 months forward. Without relative month/week/year offset integer field we are not able to do that with current Related Date Slicer. It would be great to have this feature added so that we can all together eliminate unnecssary so many offset fields we have to use in each of those reports.
RE: Dynamic Date Slicer (improve relative date slicer)
The problem I run in to a lot with the date slicer is that a lot of my views are by month (not day). So, when I want to use 'between' , that option is not there. It is there if you use days from your datetable, but not MonthYear. Please add between as an option for months.
I realize that I can just list all of the months in a dropdown, but that looks bad and takes up screen space...or I can use a different visual that looks better than the dropdown, but it doesn't have between either. So, I have to manually click each month if I want to see a whole year.
This could easily be fixed without having to re-invent the wheel. I don't see why Microsoft can't solve simple changes to make the visuals better. Seems like they are outsourcing the visuals to 3rd parties. I am not totally against this, just am against it for standard visuals like a date filter.
RE: Dynamic Date Slicer (improve relative date slicer)
Its important to give abbility to chose begining of the year (its not always Jan-Dec) and begining of the week. In this case YTD, QTD WTD etc will be calculated correctly.
RE: Dynamic Date Slicer (improve relative date slicer)
The date slicer really needs to be rethought ... a lot of gaps.
Ideally there should be only 1 date slicer for both absolute & relative date picking with the option of customizing it ... relative value selection should be above/below the absolute date selection
RE: Dynamic Date Slicer (improve relative date slicer)
Hi, any news?
RE: Dynamic Date Slicer (improve relative date slicer)
Having the slicer filter by time (hours, minutes, seconds) would be useful. This should also be built into the standard date hierarchy for date/time data.
RE: Dynamic Date Slicer (improve relative date slicer)
There really needs to be a way to turn off the relative date filter. E.g. Say that you are currently looking at This month. But now you want to look at all dates.. Currently, the only way to do this is to change the slicer to drop down or list. You can not turn off the relative date slicer.