How can we improve Power BI?

Better Date Range filters

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.

1,033 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Peter Eliason shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    67 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Bill Brennum commented  ·   ·  Flag as inappropriate

        How do I set a max and min date on the slicer? I am slicing on a date that has dates from 2010 to 2015 but the slicer ranges back to 1900

      • Sokon commented  ·   ·  Flag as inappropriate

        What about selecting a single value with the date picker, no "between" or "after", just a plain single value. The dropdown or list provide me with hundreds of values that i can't filter. Instead I'd prefer a date picker.

      • Jo-Anne commented  ·   ·  Flag as inappropriate

        There should be a 'on' option for the calendar. Sometimes you want to return a single day of data, when this is the case the user either has to select the same date twice in the calendar, or has to select from a drop-down or a list. As you can imaging these options are not ideal for data that spans over a long period of time.

      • Deepa commented  ·   ·  Flag as inappropriate

        can we have an input date field (other than date picker) in power bi which automatically filters the reports for that week.

      • Sergio commented  ·   ·  Flag as inappropriate

        Another feature to add is selecting one single date. Now you have to select "Between" and pick the same date twice

      • Michael commented  ·   ·  Flag as inappropriate

        Still not there. I like the one from the gallery (Timeline) as it is more intuitive and can range select from the bar. However, it does take up too much real-estate. If the selection bar did not resize, and one can set a default date selected, it would be the best time slicer available.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Date slicer is an improvement, but the slicer should be able to group by Year, QTR, Month, Week. If my data covers a 5 year span the slicer should automatically offer the groupings above

      • hugh.cox commented  ·   ·  Flag as inappropriate

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

      • Anonymous commented  ·   ·  Flag as inappropriate

        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        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.

      • Adam Kruzel commented  ·   ·  Flag as inappropriate

        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

      • Mike commented  ·   ·  Flag as inappropriate

        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 commented  ·   ·  Flag as inappropriate

        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.

      • Michael commented  ·   ·  Flag as inappropriate

        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.

      • Mohamed commented  ·   ·  Flag as inappropriate

        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 ?

      • Anonymous commented  ·   ·  Flag as inappropriate

        how can you sale a BI software without the base run time parameter (filter) , please add this very basic and needed feature to the report

      ← Previous 1 3 4

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.