How to chart changes over time from one item to another item (to another) sankey chart

[DanielGilbey]

Hi all and while I did look for answers, nothing immediately seemed to be what I'm looking for.

I have some data that shows the changes in solutions used by organisations over time (tracking trends) and I'm having a challenge working out how best to model and visualise this within PowerBI. I have three points of data in a format similar to the below. 

Company	Item	Year	Item	Year	Item	Year
ABC	Contoso	2010	Viper	2015	Jester	2018
DEF	Maverick	2010	Viper	2014	Iceman	2018
HIJ	Goose	2010	Jester	2016	Iceman	2018

I'm planning to be able to show that

company ABC went from Contoso to Viper to Jester

whereas

company DEF went from Maverick to Viper to Iceman

and so on... 

And, if possible, to show this as a relationship chart that somehow highlights the people using 'Viper' (for example) went to either Jester or Iceman

My thinking is a unique count of entries for the start (so 10 Contoso, 15 Maverick, 20 Goose) and from these it stems off to the next level (so 10 Contoso go to 5 Viper and 5 Jester) etc.. Ideally in the form of a sankey chart.

Any help/guidance/pointers GREATLY appreciated!

[DanielGilbey · Accepted solution]

Seems like I may have solved this myself 👍

I hadn't realised that using the Sankey visualisation would essentially give me exactly what I was hoping for - just need to tidy up my data a little and I'm good to go!