Skip to main content
Microsoft Idea

    Power BI

    Completed

    Relative Date Filter

    Vote (16) Share
    Scott A's profile image

    Scott A on 03 May 2017 01:44:21

    I love the new relative dates option in the Slicer visualization. However, we need this functionality in the Filters section of any given level: Visual, Page, Report.

    I want a user to come to a report that is already filtered on "Yesterday" or "Last Week" with no slicer visualization taking up precious space on the screen.

    Administrator on 06 Jul 2017 13:10:36

    You can now use relative dates on filters as well! Learn more in our blog post: https://powerbi.microsoft.com/blog/power-bi-desktop-july-feature-summary-2/#rename

    Comments (11)
    Scott A's profile image Profile Picture

    Arno Hoedelmans on 05 Jul 2020 23:55:44

    RE: Relative Date Filter

    Hi i miss the option to filter for last calanderyears including current year!

    Scott A's profile image Profile Picture

    Christopher Wright on 05 Jul 2020 23:37:06

    RE: Relative Date Filter

    If you are wanting QTD in the Relative Date Filter please vote for it.
    Link: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20593993-financial-year-and-quarterly-relative-date-filter

    Scott A's profile image Profile Picture

    Terry hull on 05 Jul 2020 23:18:32

    RE: Relative Date Filter

    Is there a way that the dates can use local time? the use of UTC means the days can be a day out at critical times like month end.

    Scott A's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:14:47

    RE: Relative Date Filter

    Hi. Like others have mentioned, I too like the relative dates option but would have loved it if there was an option for Quarter as well because we need to analyse a lot of quarterly data. Thanks

    Scott A's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:09:24

    RE: Relative Date Filter

    why i can not see relative filter in my old files.

    Scott A's profile image Profile Picture

    Esben on 05 Jul 2020 23:07:27

    RE: Relative Date Filter

    Hi i have a list of employees with stopped date - i need to show all people with stopped date within 2 month or with empty stopped date - how can i combine a relative date search with a or = 0 the datasource is a SQL Analytics

    Scott A's profile image Profile Picture

    Roel Dijkstra on 05 Jul 2020 23:02:50

    RE: Relative Date Filter

    Week running from Monday through Sunday instead of Sunday through Saturday would be even better.

    Scott A's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 22:54:48

    RE: Relative Date Filter

    It would be great if there was an option to filter QUARTERLY. Currently I can see Days, Weeks, Months and Years. Quarters would be a metric to have too.

    Scott A's profile image Profile Picture

    David Pugh on 05 Jul 2020 22:53:07

    RE: Relative Date Filter

    Would it be possible to add a quarter option for the relative date filter? I would like to be able to set the filter to show data just for the quarter that is current and not show data from multiple quarters.

    Scott A's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:48:49

    RE: Relative Date Filter

    '@Ralph, this feature is currently only in Slicer form - not Filter form. Scott is requesting that this feature be made available from the filter pane as well, so we don't have to use slicers on the page.

    According to the Power BI Team's May 2017 update: "We’re planning to incorporate this relative date approach into the Filter pane in a future update as well."