Relative date filtering

Relative date filtering is available for date columns at all filter scopes (report, page, and visual) and for slicer visuals. These dynamic filter conditions, such as the last 30 days (relative to the current date) promote both data freshness and query performance since the minimal amount of history required can be retrieved. Additionally, relative date filters can often avoid the need to create custom DAX measures to support specific date filter conditions.

In the following example, five report pages are dedicated to a specific relative date filter condition:

Relative date filter conditions per page

A page-level filter ...

Get Mastering Microsoft Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.