Slicers not working - Calendarauto table, not filtering date/time format

[campelliann]

Hi people,

So I have this situation. I created a calendar table and the "Date" in date/time format  is not able to filter in slicers the dates from a fact table. The dates in fact table are also in date/time format and come from a SQL database.

Then I went to power query, and changed the date format from the fact table, from date/time to date and it started working.

Why is this, and do I need to duplicate columns in the fact table with a date format? Because I also need the hours..

[amitchandak · Accepted solution]

@campelliann , It always good to have a date without a timestamp.  This can make sure you have a join with other dates easily.

Changing format in DAX, do not ensure that DateTime is the only date. It still remains date with time

In power query you can get date like

DateTime.Date([Datetime column])