Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Multi Level Sankey Help

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.

jostho99_0-1646241031151.png

First I combined the table by using a union

jostho99_1-1646241583413.png

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

jostho99_2-1646241754595.png

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!

 

 

1 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.

View solution in original post

13 REPLIES 13
DanielGilbey
Frequent Visitor

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
Super User
Super User

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
Not applicable

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? 

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
Not applicable

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 

jostho99_0-1647527469706.png

 

jostho99_1-1647527511273.png

 

 

 

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
Not applicable

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.

jostho99_0-1647541591831.png

 

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
Not applicable

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.

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
Not applicable

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

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
Not applicable

@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.

Level0Level1Level2Level3Level4Level5Level6Basecomp
6075_8WP8617_7R8155C_6R98300_5_4_3_2R98300_1
6076_8WP8617_7R8155C_6R98300_5_4_3_2R98300_1
6077_8WP8617_7R8155C_6R98300_5_4_3_2R98300_1
6000_8WP8617_7R8155C_6R98300_5_4_3_2R98300_1
6013_8WP8617_7R8155C_6R98300_5_4_3_2R98300_1
6512_8WP6515_7R8611_6R8155C_5R98300_4_3_2R98300_1
6513_8WP6515_7R8611_6R8155C_5R98300_4_3_2R98300_1
6550_8WP6515_7R8611_6R8155C_5R98300_4_3_2R98300_1
6076R_86076_7WP8617_6R8155C_5R98300_4_3_2R98300_1

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.