Help on Structuring Data for Sankey Chart

[Anonymous]

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.

VisitID	order_date	lasttouchchannel	Ordered?	VisitNumber
ABC123	10/2/2017	Other Campaigns	0	1
ABC123	10/3/2017	Direct Mail	0	2
ABC123	10/4/2017	Direct Mail	0	3
ABC123	10/4/2017	Email	0	3
ABC123	10/5/2017	Direct Mail	0	4
ABC123	10/6/2017	Affiliate	1	5

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

[v-shex-msft · Accepted solution]

HI @Anonymous,

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.

Regards,

Xiaoxin Sheng