Issue with Date and Sales Visualization in Power BI

[_Ester_]

Hello all!

I am experiencing an issue with visualizing my sales data over time using Power BI Desktop. When I try to include the date and the column with the expenditure per single order, I am unable to display this data, for example, in a line chart.

The date table is created using the CALENDARAUTO(12) formula.

You can find two sample files and the PBIX file with the data already loaded here:
https://drive.google.com/drive/folders/1SabsEKqw5ERx9ipk7tRe61xko5Yog02K?usp=sharing

What could be causing this problem? What am I doing wrong?

Thank you!

[_Ester_]

Thank you @HotChilli, it works!

[HotChilli · Accepted solution]

The relationship is not finding any matches.

paid_date has date/time that doesn't match with the Dates table because of the time portion.

Possible solution : remove the time portion and make both fields date only.