Datetable slicer not working

[djillbunters]

Dear,

I have a datetable and a table with deals.
I have a relationship between "Date" from the date table and "created_at" column. The created_at column is a date column.
When I use a slicer for "Year" for example, it just shows nothing.

But when I remove the relationship and just use "Year" from the created_at hierarchy in the deals table, it does work.

I'm doing the exact same thing with another Deals table and other tables, and there are no issues, only with this table.

The source is a SQL table where the data type is also Datetime.

I'm at a loss, no idea what the issue might be.

[djillbunters]

So instead of just selecting "Date" as the data type, I did it through transformation.
Transform and then "date only" and that was the solution.

Thank you very much!!!

[HotChilli · Accepted solution]

It's possible there is a time portion on the 'created_at' field which prevents a match with the field in the date table.