Values different when entered in Line & Cluster Column Chart

[jongee]

Hi All

I have created two separate Cluster charts in Power BI desktop and they work great.

If I try and move the bottom chart into my top Line & Cluster Column Chart the data appears to display the same value for each month. (Yellow line).

Both the date fields are returning a date format of 'DD/MM/YYYY' and are set as a date field in PowerBI. 

The data is being pulled in from a ODBC connection.

Any help would be great.

[Anonymous]

How many dimensions / tables do you have?

Is part number a measure or columns?

Sometimes I switch the chart into Table View to check my raw data, maybe if they are from different tables, relationship might not be right / created?

Might be useful to see the diagram view of your data?

[jongee · Accepted solution]

Thanks for the response. I have not managed to correct the issue yet, but I did completely forgot about setting the relationship.

I have two tables one showing items that have been processed and the second showing new items that have been created (not all created items are processed). 

So I want the line to show the number of items created and the columns show the number of items processed.