Better Date Range filters

[peliason]

The timeline slicer (Custom Visualization) functions, but it is not a friendly tool. If I quickly want to select a "Start" and "End" date for a date range, it would be more helpful to have a popup calendar with an optional freeform text box for both the "Start" and "End" date ranges.

[mbate2]

I love how little real estate this takes up compared to the custom Timeline visual, but 2 ideas for improvement: 1) Show a date axis under the timeline and 2) Add the ability to toggle "snap to" Week/Month/Quarter/Year, more similar to Excel's Timeline.

[jukka_tuomela]

Date slider is really good new feature but I also totally agree what Michael said. There should be default time scale on when you open the page. That default time scale should running automatically forward example if default is a month date slider should set time from first day of the month to the current day of the month.

[melmessaoudi]

Hi, a better data range filter is avalaible for PowerBI online, but I don't find it on PowerBI desktop, will it be included in the next update ?

[michaelm3]

I like the idea but still need to have something more robust. I have a value that comes in on the first of each month. I want to show "month" selection and not a calendar start and end. Think of same for Year and Quarter. There is a Timeline visual available that is close to what I expect but the slider area resizes unfortunately and not a fixed size on the report. Also, setting a default value (if a user clicks in the white space, it should show the "default" value of latest month and not the total of all months and all years. Perhaps a method of educating the executives when clicking within slicers. One could have a "Select All" option but when clicking in the white pace, it goes to the latest month in the data.

[florent_bacs]

An update that would allow us to pin a universal timeline slicer onto a dashboard would be amazing. Doing so would enable management to alter the timeline of all reports being shown on a particular dashboard.

[akruzel]

I made another request here to just make the timeline slicer like the one in Excel for those who think it looks and functions better. https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17057929-recreate-excel-timeline-slicer

[thejoneszoo]

The updated slicer does not seem to work quite right when using the "between" option. It is automatically adding one day to the end date. For example, I have a table that shows me a list of patients seen as well as their insurance carrier. I then built the slicer to use the date of service field so I can pull a list of patients for any given date range. If I input that I want 11/01/16 - 11/02/16 my list shows me patients for 11/01/16 - 11/03/16. When I change it to a list display I can pick just those two dates and get only those dates.

[akruzel]

Correct me if I'm wrong, but didn't you just reverse the change completed here? If managers want to know how November performed, they'd rather just click on November in a timeline slicer rather than having to select November 1st and November 31st. Help me understand why this can't just be made to resemble the timeline slicer already in Excel? https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7865136-timeline-slicer-for-date-month-quarter-year

[sajid_mansoor]

well done

[HughCox]

Simple From To date function which is permeated throughout all tabs. Very basic should have been part of the initial version.