Fail to connect with date table to create filter slicer

[rachelbi]

Hi there, may I know why I cannot connect the date table with a date field in a fact table? after making connection and add the slicer, the table turn blank ... Thanks a lot in advance.

Before:

After adding the slicer:

I thought the relationship should be correct?!

[amitchandak · Accepted solution]

@rachelbi , This can happen

1. The date in the date table was having timestamp (and you just made data type as Date in DAX). Create a new column Date = Datevalue([project Created at] )

This will remove the timestamp  and join will work

2. Date table is missing date that in fact table

3. You are using a relative date slicer and that is filtering from today and you do not have data for selected range

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[rachelbi]

Thanks @amitchandak The first suggestion works! I thought I can simply change the date format on the same original column as it was text format (don't know why). Thank you.