Beginners Line Chart Issue

[Bobby2bees]

Pretty new to this so sure this is a straight forward thing to solve but I’m trying to include two lines in a line chart and the second line is just a flat line even though the data is not all of the same.

For example the data is
Jan 120
Feb 150
Mar 100

But instead of showing these value the line just shows all periods at 370 (the total of the 3).

Any ideas what I’ve done wrong?

Thanks

[v-yulgu-msft · Accepted solution]

Hi @Bobby2bees ,

Did you add Month column from this table onto chart axis? If so, it would sum up values per period automatically.

Besides, please try to add below measure into chart.

Measure =
CALCULATE ( SUM ( Table[Value] ), ALLEXCEPT ( Table, Table[Month] ) )

Best regards,

Yuliana Gu