unable to filter date

[Anonymous]

hello ,
sharing my data, i have multiple values for same date , i have created calendar table using date of fact table but when i try to filter the date i am unable to do so , please help

[tamerj1]

Hi @Anonymous 
Apparently the dates in your fact table have different times. The dates in the date table have the default time which is 00:00:00 for example 01/01/2022 00:00:00 which probably relates to non of the date-times in your fact table.
Changing the format from the formatting pane drop list to date only won't help as this only changes how the dates are displayed but the the actual value of the DateTime.

You need to create a date only column that is simply DATEVALUE ( FactTable[DateTimeColumn] ) then link the date table with that column.

[FreemanZ]

hi @Anonymous 

Even the calendar table is created using date of fact table, you still need to relate them. are they related?

[Anonymous]

@FreemanZ  thank you for your reply, this is how i have created calendar table