Timeline slicer default to previous month

[Agent766]

I'm using the timeline slicer from the gallery. I would like for the default range to have the previous month selected instead of the entire year. Is this doable?

[samdthompson · Accepted solution]

Hi, no this is not possible. If you want a previous month as a default, why not create a calculated column to use as a filter. Assuming you have a date table, something like:

IF (
    AND (
        Data[Date]
            >= DATE ( YEAR ( NOW () ), MONTH ( NOW () ) - 1, 1 ),
        Data[Date]
            <= DATE ( YEAR ( NOW () ), MONTH ( NOW () ), 1 ) - 1
    ),
    "previous month",
    ""
)

>>>if this is a solution please mark as such.

[AndrewDang]

Thanks. This works great for me.

Andrew