Relative date not showing

[ZakariaFassih]

Hello,

I have a database with field composed of a dates like this 01/01/2023and i want to add a filter on the visual to only choose a year for exemple 2023 or 2022.

After few searches the filter is called "Relative date" but i cant find it on my power bi options.

Thank you.

[HotChilli · Accepted solution]

What data type is the field?  It represents a date but is it a date type?

[ZakariaFassih]

Hello HotChilli,

Thank you for your answer, the data type was texte i changed it to "date" and the option for "realtive date" has became visible in the options now👍.