2 lines on a chart with different x series

[Johnson]

Hi, I have 2 series, each with their own x and y columns (in different tables)

Series 1 has its x col as 5 dates amd its y col as 5 values

Series 2 has its x col as 10 dates and its y col as 10 values

I want to plot both Series 1 and Series 2 on the same chart, with each series plotted as a line

The challenge here is PowerBI has to be smart enough to use 2 different x series (even though each is a date/time)

In Excel this is easily done as an "xy scatter plot" because there each series can be inputted with its own x series and y series (and the chart figures out what the overall min and max of the x and y axes should be)

I am finding this very hard to do in Power BI. Any suggestions please?

Thanks

[v-luwang-msft]

Hi @Johnson ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[parry2k]

@Johnson can you share sample data with the expected output?

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.