How Do You Build This? Is it Sankey?

[lwall_mba]

Hello all - I have been trying to create this in Power BI, see picture attached. 

https://drive.google.com/open?id=0B3TWgPuEn9sYNlFHV1ZlOFJUdW8

All Sankey charts I used, failed because they don't automatically group categories by month (t, t+1, t+2, etc.).

I want the boxes to change sizes depending on the number assigned to those labels.

Also, the size of the arrows connecting the boxes should have the size of the numbers departing one label and connecting to other. 

Another important aspect is that not every label gets an output/destination. See mainly the top ones.

If this is possible with a Sankey diagram, how does the data have to look like?

[v-sihou-msft · Accepted solution]

@lwall_mba

If you want to change the size based on associated labels, you can try the custom visual Sankey with Labels. But you have to keep t+1 connecting either side. If item in t+1 hasn't connected any side, it will not be displayed. 

Regards

[fclbri]

Hi, I have used Sankey with Labels well but I cannot get the .pbiviz files anymore. if you do not mind, could you send me the file to my email? my email is choi@worldsteel.org