Reply
Frequent Visitor
Posts: 10
Registered: ‎06-05-2017
Accepted Solution

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


Accepted Solutions
Community Support Team
Posts: 7,505
Registered: ‎08-14-2016

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: | |

View solution in original post


All Replies
Community Support Team
Posts: 7,505
Registered: ‎08-14-2016

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: | |