Correct Way to Fill out Date

[CuriousGuy001]

Hi everyone,

I was wondering what is the correct way to populate the date format for Excel in order for PowerBI to make a good relationship from Calendar table to the Date of the Excel Worksheet. Below is how I make my date table in Excel,

Whenever, I connected with multiple _facttables, [Above the image is one of them], wont work properly if I connect to the Calendar table, 

Any recommendation to improve my experience using PowerBI, I would greatly to open to hear. Thank you!

[CuriousGuy001]

Thank you I found my answer!

[ryan_mayu]

have you changed your date column to Date type in powerbi?