How to connect a list of two xy series (start-end points)?

[cozywolf]

Hello

I am trying plot a few hundred or maybe thousands of paired (start and end) xy series with a line connected the two points. I have done it successfully in Excel by follwoing this tutorial The data and the plot look like this:

I am wondering if I can do the same in PowerBI so I can add filters to filter the data base on the criteria.

Thanks

[cozywolf]

To fenchurchio

This is perfect, thanks so much for the help.

To v-chuncz-msft (Community Support Team)

I didn't know that it can interface with R, I will definitely look into it.

[Anonymous · Accepted solution]

If you model your data like the below then you can use the native line chart visualisation.

You need to do the following:

1) Add a unique transaction \ event id

2) pivot the start and end coordinates onto their own row

I have included the solution on a PBIX workbook you can download here: Download

[stefano123]

Hi, 

thanks, this is exactly what I was looking for. However, this does not seem to work with vertical lines or am i doing something wrong?

thanks

Stefan

[v-chuncz-msft]

@cozywolf 

You may try Create Power BI visuals using R.

https://www.rdocumentation.org/packages/graphics/versions/3.6.1/topics/segments