Want Date slicer with future dates

[Shloka_Lakhani]

Hello,

I have one problem with date slicer. As i have future dates in check-in column and want filters based on that column.

Issue i can not select future dates. Slicer display only latest date.

[SamWiseOwl · Accepted solution]

Hi @Shloka_Lakhani 

Are you using a calendar table?
If not create a calendar table with either Calendar (firstdate, lastdate) or Calendar auto to make one automatically based on your dataset. Use that date to apply the filters.
Here is a blog about it.

[rajendraongole1 · Accepted solution]

Hi @Shloka_Lakhani - create a new calculated column and derive future date as below

New Date = date(year([Date])+2, month([Date]), day([Date]) )

[SamWiseOwl · Accepted solution]

Hi @Shloka_Lakhani 

Are you using a calendar table?
If not create a calendar table with either Calendar (firstdate, lastdate) or Calendar auto to make one automatically based on your dataset. Use that date to apply the filters.
Here is a blog about it.