Multi Level Sankey Help

[Anonymous]

I am trying to make a multi-level sankey diagram where each pilar in the diagram would be a level. This is a snippet sample data I have, the flow would be 7 goes to 6, 6 goes to 5 and so on.

First I combined the table by using a union

When I put this data into the sankey it comes out with only 3 pilars instead of the 8 I would expect

What am I able to do to fix this? Am I able to set up the sankey so that it is forced to go from one level to the other instead of just combining all of the data? Thanks!

[DanielGilbey]

Q: Did you ever solve this? I ask as I'm trying to achieve a similar (less complex) output that shows the journey from 1 to 2 to 3 

TIA

[lbendlin]

Like many other visuals a Sankey has limits on the amount of data it can display. What's the granularity of your levels, and how many permutations do you have?

[Anonymous]

Yea this is a very big set of data but I am planning to incorporate slicers into the visual so users can narrow down the visual to make it more clean. I believe that the root of my problems are that there are tons of blank values in levels 3 to 7. Is there any kind of workaround to ensure that I can make the components on the left are level 7 components and the items on the right are level 1 components? 

[lbendlin]

Some versions of the Sankey visual allow you to rearrange the items as needed.  I think you'll want to focus on aggregating and filtering your source data better before you think about the visual part.

[Anonymous]

Hey, I adjusted my data so each value in each level has an "_x" x would be the level I want it to be at.  But I noticed when I combine all these values using the same formula I used up above, not all data points were being transfered over and not all things were even being shown on the sankey. Do you know why this is happening. For example here is an image of my sankey and here is an image of my new data table. As you can see, none of these values are actually listed on the sankey. @lbendlin 

[lbendlin]

I don't see any grouping yet. Note the blue i  icon - too much data for the visual.  I don't think Sankey is the right visual for whatever story you are trying to tell. 

If you like more help please post sample data and show expected outcome.

[Anonymous]

The story I am trying to tell the flow of different componets going into different products. This is a diagram that I am trying to make in Power BI, I made this is R but I was struggling to put it in PowerBI.

[lbendlin]

How is that black blob helpful to anyone?  you are suffocating the visual with way too much detail.  That's why I was asking if you could group/aggregate your data into a more palatable cardinality level.

[Anonymous]

The values will be filtered down and will look like a normal graph. For example a user will select one finished product or 2 and it will appear normally.

[lbendlin]

I still don't think that a Sankey is the right visualization for this. In my opinion it has a different purpose - to show the journey of an object through various states/phases.  It is not a hierarchy visual.

[Anonymous]

Do you have any substitution visuals to what I am trying to achieve? I am just trying to show the flow of components to final products in both directions. If the user selects a component it shows the components of where it came from or where it is going and for a finishsed product selection it will show all of the components that went into it. Thanks

[lbendlin · Accepted solution]

This sounds like the lineage view that you can use in Power BI Desktop and Service to trace data sources and sinks.  Maybe there is a custom visual that covers that? Search for "network"  in the visuals store.

[Anonymous]

@lbendlin  This is a snippet of sample data that I have. The flow would go from Basecomp to Level6 to Level5 and so on until it reaches Level0. The values after the underscore indicate the level the item should be on. If an item is like this for exmple, "_2" then it does not have any values it it but I still want it to appear in the graph at the second level and have nodes connecting to it.

Level0	Level1	Level2	Level3	Level4	Level5	Level6	Basecomp
6075_8	WP8617_7	R8155C_6	R98300_5	_4	_3	_2	R98300_1
6076_8	WP8617_7	R8155C_6	R98300_5	_4	_3	_2	R98300_1
6077_8	WP8617_7	R8155C_6	R98300_5	_4	_3	_2	R98300_1
6000_8	WP8617_7	R8155C_6	R98300_5	_4	_3	_2	R98300_1
6013_8	WP8617_7	R8155C_6	R98300_5	_4	_3	_2	R98300_1
6512_8	WP6515_7	R8611_6	R8155C_5	R98300_4	_3	_2	R98300_1
6513_8	WP6515_7	R8611_6	R8155C_5	R98300_4	_3	_2	R98300_1
6550_8	WP6515_7	R8611_6	R8155C_5	R98300_4	_3	_2	R98300_1
6076R_8	6076_7	WP8617_6	R8155C_5	R98300_4	_3	_2	R98300_1