Setting a dynamic date anchor for relative time slicer

[Haidarius]

Hello!

I have a date slicer that filters some payment dates for me which I have set for the next 4 months. It originally uses today's date.

I need to have the date be the beginning of every current month instead of the current day so instead of below:

It would be 11/1/2022 - 02/28/2023 (Relative to this month November) and change when December comes etc...

Any help is appreciated,

thanks!

[MahyarTF]

Hi,

There is another choice in the last drop-down in the specific visual (Months (calendar), when your choice that, it is shown the particular months date regarding the number you entered :

As you see I chose the Next- 3 - Months (calendar) and the dates are filtered between 1/12/2022-28/02/2023

Appreciate your Kudos and Please mark it as a solution if it helps you.

[Haidarius]

Hello Mahyar,

This option will make the filter go to the next 3 months starting the next month, so choosing it would lead the filter to start at December 1st instead of November 1st..

[MahyarTF · Accepted solution]

Oh,

You mean the first of the current month and the next 3 months. it is a combination of past and future.

In my idea, you need to create another date dimension that is included the all current month and next 3 months based on the current month