How to default a value in a relative date slicer.

[melvin9900]

Hello,

   I have a report which uses the releative date slicer as the filter. The source is Time dimension.

The values are defaulted to last 5 months.  The values should dynamically change on the 1st day of the month. For example

on 9/1/2022  the slicer should default to last 6 months and on 10/1/2002 it should be last 7 months and so on.

The number of months vaules should automatically increase on the first day of month so that bottom value of the filter is always 3/30/2022. 

I tried few options and didnt know how to achive this. Any help is appreciated.

[HoangHugo · Accepted solution]

Hi

I know the number of month is fixed in relative slicer

in your case, if want fix date "3/30/2022", you can use "anchor date", and use "Next" option

Or you can munually create some formula, measure and slicer, and combine them into a visual to have a slicer like you want