Forum Discussion

ZakariaFassih's avatar
ZakariaFassih
New Member
2 years ago
Solved

Relative date not showing

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.

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

2 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion

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

    • ZakariaFassih's avatar
      ZakariaFassih
      New Member

      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👍.