Filter 2 Relative Dates

[Anonymous]

Is there a way/visualization that enables you to filter between 2 relative dates in Power BI without a DAX expression? I want to avoid DAX as we're looking for a simple slicer visual that can enable us to slimply move between 2 relative dates.

Example: on Slicer 2.1, If I select 2 dates they stay the same since they are not relative. But we want to select 2 dates: 6 months in the future and 12 months in the future. Is there any visual or way to achieve this?

Thanks,

[TomSmith]

The way I solved this, was to add an extra column (should be able to do exactly the same with a measure but it wasn't working for me so I had to add a column), and the DAX I used was ShiftedDate = DATEADD('TableName'[DateField],6,MONTH), then I added that to the page filters and selected "in the last" and 6 and months - and this then gives you between 6 and 12 months. 

[v-rzhou-msft]

Hi @Anonymous 

You can achieve your goal by creating a relative date slicer or filter.

I build a table to have a test.

1.    Relative date slicer:

Build a Slicer by Date value and select Relative Date.

If you want to get the date in the future 6 month, you can select Next 6 Month(Calendar).

Result:

Relative date filter:

Click apply filter.

Reuslt:

For more info about relative date slicer or filter, refer to this link: Creating a relative date slicer and filter in Power BI

You can download the pbix file from this link: Filter 2 Relative Dates

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Anonymous]

Hi Rico,

What I actually mean is to filter between to dates in the future. For example, between the next six months and the next 12 months. Not just one of them.

Thanks,

Rashid 

[v-rzhou-msft · Accepted solution]

Hi @Anonymous 

We can achieve your goal by build a Calendar Table.

Calendar = CALENDARAUTO()

Build a relationship between Date in Table and Date in Calendar Table.

Then use this table to build a Slicer.

When you want to see the data between the next 6 month and the next 12 month, you can select the day between 2021/2/28 and 2021/8/31.

Result:

 

Currently, we can't use relative date slicer or filter to get the date between the dates in the future in power bi.

You can vote for this function in this idea: Idea

If this idea is not suitable for you , you can submit a new idea as well.

You can download the pbix file from this link: Filter 2 Relative Dates

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[Anonymous]

Yes, I submitted that idea. It would be really helpful if that functionality was added. 

[v-rzhou-msft]

Hi @Anonymous 

Please mark the helpful answer as a solution. If you mark the answer as a solution, this post will be easier to others to find. And other people could vote up your idea as well, so this function may be realized faster.

Best Regards,

Rico Zhou