cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cozywolf
New Member

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

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: example.JPG

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

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

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

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

 

2019-07-22_12h43_26.png

 

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

 

2019-07-22_13h14_13.png

 

View solution in original post

3 REPLIES 3
Community Support
Community Support

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

@cozywolf 

 

You may try Create Power BI visuals using R.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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

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

 

2019-07-22_12h43_26.png

 

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

 

2019-07-22_13h14_13.png

 

View solution in original post

cozywolf
New Member

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

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.

 

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors