Multiple Lines on One Chart

Thanks for the reply from arava and ahadkarimi.

Hi e175429 ,

When using the 2024 PLEA field as the x-axis, it seems to appear as you would expect, but on closer comparison, the data is incorrect.

I will provide an alternative method and here are the steps to do it:

1.Create a new table, this table contains unique PLEA column values extracted from 2023 and 2024 (Sheet1):

Newtable =
SUMMARIZE (
    UNION (
        SELECTCOLUMNS ( '2023', "PLEA", '2023'[PLEA] ),
        SELECTCOLUMNS ( '2024(Sheet1)', "PLEA", '2024(Sheet1)'[PLEA] )
    ),
    [PLEA]
)

2.The relationship between the three tables is created as shown below:

3.Using the PLEA of the newly created table as the x-axis, you can get a line graph with the correct data:

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.