Solved: Dynamic End Date on Slicer

Pramit4u · ‎08-10-2018

We have a use case where we want the End date in a Data Slicer to show the current date or previous date whenever the user opens the report. The Start date can be set to a default value(say 01/01 of that year). Any pointers on this would be really helpful.

v-chuncz-msft · ‎08-13-2018

@Pramit4u,

You may drag date from table below.

Table =
CALENDAR ( DATE ( YEAR ( TODAY () ), 1, 1 ), TODAY () )

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎08-13-2018

@Pramit4u,

You may drag date from table below.

Table =
CALENDAR ( DATE ( YEAR ( TODAY () ), 1, 1 ), TODAY () )

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.