Forum Discussion
Multi Level Sankey Help
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.
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
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.
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 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 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.
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.