Power BI

Completed

Relative Date Filter

Vote (16)

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)

Comments (11)

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!

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

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.

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

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.

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

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.

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.

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.

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