Skip to main content

    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

    4fde28d4 2741-478c-b0ac-894b7bc6c74e 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

    7b4f08c2 0481-438b-b35a-3fa5fa115075 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

    434162b6 0ee4-4c8b-9b1d-a4e119088a3b 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

    ee332bf0 b8cb-4edb-a9ed-84a5b09e6c37 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

    2a762bef aa4d-4b46-a609-3e3f5e502f0d 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

    8e5cd334 cd38-e811-a95c-000d3a1bee29 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

    215f8fd6 d1b8-42c7-99ef-d513b2f858f8 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

    a3309361 99be-ea11-a812-000d3a8ddfb2 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

    5960af12 f940-488e-8b16-5dd1747d1d03 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

    ea22a020 93a1-4d42-98f0-1a03c24eb152 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."