How to use Relative Date Filtering to Filter Data Easily in Power BI

Relative Date Filtering is a nice feature in Power BI to filter date data. For example, in our dataset we have an Order Date and Amount:

Let’s expand our Order Date filter. We can see Relative date filtering as an option:

Expanding Show items when the value we can see the options is in the last, is in this, is in the next:

If we select is in the last, we can see we can enter a number, then select days, weeks, calendar weeks, months, calendar months, years and calendar years:

We can choose whether to include today or not:

Click Apply filter, and our data is filtered:

Change the filter to see new results:

We can also set to the current day, current week, current month and current year:

Keep learning. Keep building.

Explore AI, agents & Microsoft technology.

I share practical ideas, tutorials, and videos about AI, AI agents, Microsoft technologies, and the Power Platform.

Subscribe on YouTube →

Carl de Souza Enterprise Architect at Microsoft · AI Technology Expert