Forum Discussion
Filter 2 Relative Dates
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.
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.
Yes, I submitted that idea. It would be really helpful if that functionality was added.