Line Chart with 2 different values

[alecalma]

Hello everybody,

I want to display a line chart with two different value fields coming from two different tables. 

The problem is that only one of the two lines is displayed correctly with every value aligned to the corresponding month. The other one, depending on my selection, is always the sum of the values for every month, or the min of the values for every month, or the max of the values and so on.

It seems that powerBI can't recognize the time split for both of the lines, but only for one.

Do you have a solution? Thank you!

[MFelix · Accepted solution]

Hi @alecalma,

To what I can understand you want to make a line chart with X-axis of Dates and using different tables, you need to create a dimension table with a calendar and then make a relationship between this one and the other two tables, then use the dimension table on your axis and the values of both tables for your line values.

Regards,

MFelix