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,034 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 EliasonPeter Eliason shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    68 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 BrennumBill 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

      • SokonSokon 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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Maybe this was "improved" as of 2016, but it still needs so much work to catch up to basic expectations for a system like this. This is only a little bit of UI engineering - most startups release things like this in a week! A few configurable options that most people would consider standard:

        - configure to restrict the user to only selecting single days (with the ability to set intelligent defaults like "today" or "yesterday")
        - semantic selections like "this week", "last week", "this month", "last month", "last 7 days", "last 30 days", etc

        There are a lot of good JS/HTML implementations of these types of datepickers already available - no need to re-invent the wheel on this!

      • Jo-AnneJo-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.

      • DeepaDeepa 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.

      • SergioSergio 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

      • MichaelMichael 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.coxhugh.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 KruzelAdam 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

      • MikeMike 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.

      • JukkaJukka 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.

      • MichaelMichael 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.

      • MohamedMohamed 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 ?

      ← 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.