Forum Discussion
Date Range
Hi all,
My client has requested me to have a specific date range within a chart.
Can anyone show me how to create a date range as follows:
Min Date: Current Month - 2
Max Date Current Month +6
This should cover 9 months of data.
Thank you.
Hi Anonymous
You can downlad this calendar table and apply the filter as below.Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
13 Replies
- MariuszCommunity Champion
Hi Anonymous
You shoud be able to use Relative date filtering.
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-rangeRegards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- AnonymousNot applicable
Hi Mariusz
I do know how relative date filtering works, but I have not been able to set it for the specified range:
Min Date: Current Month - 2
Max Date Current Month +6
This should cover 9 months of data.
Do you know how to do it ?
Thanks!