Skip to main content

Power BI

Needs Votes

Better Dynamic Date Slicer

Vote (5) Share
's profile image

on 09 May 2018 19:23:44

The options from the current date slicer in powerBi are not user friendly enough. the only ones we use are :
- Custom Date (aka Between)
- PreFiltered (aka Relative)

Something like the below would be very nice and easier to use.

A widget with 3 fields selection : Period, Start Date, End Date.
- For Period, you can select Day, Week, Month, Quarter, Year, or Custom.
- When you select any of the options (except Custom) :
o “start date” is available for editing, and “end date” is disabled and auto-filled based on the start date selection
o Then, it auto populates the start date with the a few potential values : selecting day --> Day = the start date of the last 5 days, selecting week --> Week = the start date of the last 5 weeks, etc..
o you could also add : Current, Last, Last (calendar)

- If you select Custom, it turns the start date to a calendar, and enables the end date with a calendar