Forum Discussion
Filter 2 Relative Dates
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,
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.
6 Replies
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.
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.
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.
