Visuals are not appearing when I connect the date table to other table

[bourne2000]

Hi

I am having an order table that I have taken from the MySQL database. Then, I created a Date table in Power Query. I connected the date column in the date table and the order request table in the order table. 

I am trying to create a bar graph for the date vs the count of Order ID. I took the date from the date table. I am not getting visuals and date columns are showing blanks. Please advise what's wrong with my approach?

[amitchandak · Accepted solution]

@bourne2000 , your date table does not have all the required dates. Or date in the table has timestamp. 

If yes, Then create a date from timestamp  like

Date = [datetime].date
or
Date = date(year([datetime]),month([datetime]),day([datetime]))

Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw