Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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!
Solved! Go to 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.
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
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?
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.
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.
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.
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.
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.
@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 |
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
4 | |
4 | |
4 | |
4 | |
4 |