Timeline slicer default to previous month

Question

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 Answer

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:&nbsp;IF&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;AND&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Data[Date]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&gt;=&nbsp;DATE&nbsp;(&nbsp;YEAR&nbsp;(&nbsp;NOW&nbsp;()&nbsp;),&nbsp;MONTH&nbsp;(&nbsp;NOW&nbsp;()&nbsp;)&nbsp;-&nbsp;1,&nbsp;1&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Data[Date]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;=&nbsp;DATE&nbsp;(&nbsp;YEAR&nbsp;(&nbsp;NOW&nbsp;()&nbsp;),&nbsp;MONTH&nbsp;(&nbsp;NOW&nbsp;()&nbsp;),&nbsp;1&nbsp;)&nbsp;-&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;"previous&nbsp;month",&nbsp;&nbsp;&nbsp;&nbsp;"")&nbsp;&gt;&gt;&gt;if this is a solution please mark as such.

Forum Discussion

Timeline slicer default to previous month

2 Replies

Related content

Timeline slicer default to previous day

Slicer default to previous month

Slicer default selection

Date Slicer default to previous month

Roadmap/Timeline