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