Set end date as todays date in date slicer keeping date range intact

[praneshjuwale]

Hi Folks,

I have used date slicer with a date range as followed:

This is working properly.

Now i want to show end date as todays date but keeping the date range intact as above.

How to modify for the same?

Thanks in advance.

Pranesh M Juwale

[v-chuncz-msft]

@praneshjuwale,

You may simply add a calculated table.

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

[praneshjuwale]

Hi Sam,

thanks for the update.

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

But this will give me a slicer as today with end oo the date range, I don't want that.  

I want the slicer to have end date parameter in the visual as today  and the slicer can be moved manually ahead of the todays date till the end of the date range.