cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
itsanupam Frequent Visitor
Frequent Visitor

Help on Structuring Data for Sankey Chart

Hi

 

I'm trying to visualize a visitors journey until an order is placed on our website using a Sankey chart.

 ( https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380777?tab=Overview)

 

My raw data is structured as follows.

 

VisitID: Unique ID identifying a visit

VisitDate

LastTouchChannel: Last channel used when visiting our website

Ordered?: Did the customer place an order?

Visit number: Seq no. identifying the visit number ordered by date.

 

VisitIDorder_datelasttouchchannelOrdered?VisitNumber
ABC12310/2/2017Other Campaigns01
ABC12310/3/2017Direct Mail02
ABC12310/4/2017Direct Mail03
ABC12310/4/2017Email03
ABC12310/5/2017Direct Mail04
ABC12310/6/2017Affiliate15

 


In this case the chart should show the path like

 

Other Campaigns -> Direct Mail -> Email -> Direct Mail ->Affiliate 

 

I know sankey chart accepts source, destination and weights as input. I'm not sure how to structure the data to achive the visual i'm looking for.

 

Thanks

Anupam

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Help on Structuring Data for Sankey Chart

HI @itsanupam,

 

Nope, I don't think it is possible to use your table to generate sankey chain graph.

If your table contain one node which has multiple linked items, power bi will summary them and break chain graph.

54.gif

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
1 REPLY 1
Community Support Team
Community Support Team

Re: Help on Structuring Data for Sankey Chart

HI @itsanupam,

 

Nope, I don't think it is possible to use your table to generate sankey chain graph.

If your table contain one node which has multiple linked items, power bi will summary them and break chain graph.

54.gif

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 123 members 1,840 guests