Date Slicer not allowing for relative dates

[gangles]

I'm trying to do a relative date slicer similar to this link but there isn't a dropdown available under Visual > Slicer Settings > Options. 

Originally I was using a slider, but with a few years of data, it has gotten impractical, so a relative slicer seems to be a better option. I've confirmed that the "date" column is in fact, a date. I've tried clicking on the hierarchy instead but I'm still having the same issues.

Thanks!

[TomMartens · Accepted solution]

Hey @gangles ,

make sure, that your column is of data type date/datetime and the hierarchy option is not selected, instead the date column. Be aware that my date column is named datekey, this can be somewhat misleading:

Then the "Relative Date" Style will appear on the Options card of the visual properties.

Hopefully, this helps to tackle your challenge.

Regards,

Tom

[gangles]

Hi, thank you for the response.

Just had to click on the dropdown and change it to relative here. Simple enough and thank you for the help