Forum Discussion
Sankey diagram question
Hi All and happy new year.
I am new to Sankey diagram and I need some help.
I need to present product reconcilliation with each stage of manufacturing (inputs and outputs). Specifically, there are 6 input materials that will be used to make one intermediate product. This intermediate product will be used to make another intermediate product and finally, this intermediate product will be used to make the fina product. With each stage of manufacture, there are some losses and samples that need to be accounted for. How do I make this diagram?
Thank you
4 Replies
v-cherch-msftMicrosoft Employee
Hi SankeyUser
You may check the sample file. Here is the blog from the power bi team. For more details, you may refer to this article. If you need further help,please share some sample data.
Regards,
Cherie
Hi Cherie,
Thank you so much. the sample file was very helpful. I will try it on my exaple and will see how it goes.
Regards,
So I tried to follow the sample file and this is what I got.
I am not sure if this is clear but this represents different stages of manufacturing, where in every srage, there is waste and samples. Ultimately, the accountabilty should be 100% (my good product, plus waste plus samples). Here are 3 things I need help with:
1. How can I make the components of each stage appear consistently? for example, product, samples, and waste. I arragned the data in this this order but the driagram mixed up the order.
2. Why the lines are crossed? How can I make them parallel or at least not crossed.
3. How can I show the break up date for each stage? for example, the amount of product, samples and waste.
I dont know if I can attach a file but here is my data
Lot 1 Granulation 2192.48 Lot 1 Samples 0 Lot 1 Waste 33.52 Lot 2 Granulation 2176.18 Lot 2 Samples 0 Lot 2 Waste 49.82 Lot 3 Granulation 2183.84 Lot 3 Samples 0 Lot 3 Waste 42.16 Lot 4 Granulation 2176.25 Lot 4 Samples 0 Lot 4 Waste 49.75 Lot 5 Granulation 2204.88 Lot 5 Samples 0 Lot 5 Waste 21.12 Lot 6 Granulation 2194.41 Lot 6 Samples 0 Lot 6 Waste 31.59 Granulation Blend 14168 Granulation Blend Samples 236 Granulation Blend Waste 262 Blend Compressed Tablets 13060 Blend Compression Samples 118 Blend Compression Waste 1252 Compressed Tablets 90's Mono 3500 Compressed Tablets 90's Multi 3540 Compressed Tablets 1000's 6500 90's Mono 90's Mono bottles 2056 90's Mono 90's Mono Samples 177 90's Mono 90's Mono Stability Samples 1097 90's Mono 90's Mono Micro Samples 47 90's Mono 90's Mono Waste 0 90's Multi 90's multi bottles 2207 90's Multi 90's Multi Samples 177 90's Multi 90's Multi Stability Samples 1097 90's Multi 90's Multi Micro Samples 59 90's Multi 90's Multi Waste 0 1000's 1000's bottles 1835 1000's 1000's Samples 393 1000's 1000's Stability Samples 3670 1000's 1000's Waste 0
