Dynamic Date Slicer (improve relative date slicer)

[pbiideas1]

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

[victorfranco]

The relative date filter released in july is great, but it is missing the "Quarter" option, that seems to be so easy... Hope it appears in the next update.

[lucas_sanchez04]

Would be great a date picker like Google Analytics or this awesome webapp https://demo.baremetrics.com/. The new date slicer is far away from that. It's not User Friendly at all.

[carl_hannes_wal]

You should also be able to select start day of the week. Currently it defaults to Sunday with no way of changing it.

[daniel_hjorvar]

Kinda clumsy but the relevant date slicer shows Next 1 Days = Last 1 Days which clearly doesn't make any sense. Hope this gets fixed

[awilbourn]

The time calculations should also include accounting calendars like 4-4-5 and not assume a calendar year calendar. It would seem that common accounting calendars should be set in the tool and we choose the one we need based on our accounting implementation. Having things built within the tool has a higher chance it will work efficiently as there are a lot of smart people who work on the project. We find our calculations that we created seem to work, but feel slow.

[pbiideas1]

We need YTD, QTD, MTD so from Jan 1 to today. We need these to also be flexible for fiscal dates that don't start on the 1st. This is a huge need.

[john_sanford]

Any "YTD/MTD" is of marginal usefulness unless the START date can actually be set. Is that Fiscal YTD, Calendar YTD, or School Year YTD?? MTD is not as much need, although some folks DO set the start of their Fiscal Month other than the First. Just not very common.

[kamarck]

Would also be helpful to have a "from today until X Date" option to show remainder of the year/month/etc.

[adam_henderson]

Would be great if the report consumer could have 1 date slicer that can switch between relative and the sliding date slicer in a live report...this would be more user friendly because it could be defaulted to relative for live data but if someone wanted to see a range of dates or specific dates we wouldn't have to add a second slicer and they wouldn't have to open up the relative date slicer with so much data they don't really need they could just flip back and forth.

[laurence3]

I think that there is also an important distinction between the actual date and the date that data was last updated in power BI that the current date filtering/slicing doesn't deal with. What I mean by this is that sometimes one would want to filter date dynamically based on the last date available in the data... N.B. this is different to current date for anyone not privileged enough to have robust daily/quicker updates. For example... one table of mine consists of historical stock level data where each product has a stock level for each 'as-at-date'. I am often away from the office for a few days at a time, and unfortunately due to server limitations I need to be on premises to update my data. In the mean time it is very useful to analyse based on what the latest info is. Doing this currently means that I will often need to go into my various reports to manually adjust the 'as-at-date' being used to be sure that I am using the latest data.