Line chart trouble shooting - won't display joined table correctly (.pbix example file attached)

[Anonymous]

I have a line chart that won't display how I want. See attached .pbix file as example. I have one table that is shipments data. Another table that is a goal table. The two tables are lnked by a date table.  I want to plot the shipments by day and the goal by day. The shipments line correct is correct as it show the number of units shipped each day. The goal line is just flat as it's showing the average of all the days but it should show the goal (which changes) for each day. The below picture shows what I want (the flat dark blue line at the top should be like the red line that is drawn)

Here is the .pbix file:  pibix file 

[HotChilli · Accepted solution]

Just swap out the date that is on the x-axis for the date from the date table.

[amitchandak · Accepted solution]

@Anonymous , Date has to come from the date table.  Please find the attached file after Signature.

[HotChilli · Accepted solution]

Just swap out the date that is on the x-axis for the date from the date table.