Forum Discussion
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.
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!
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.
13 Replies
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.