Forum Discussion
Multilevel Sankey for internal mobility data
I'm trying to create a multilevel Sankey visual to display internal mobility within the organization. Ideally the user would select a job profile in a filter, and the sankey would show the job profiles people had prior to the selected job profile (the source) and the job profiles people had after the selected job profile (the destination). It would essentially be a career path using historical data. I've (kind of) gotten it to work using two separate Sankey visuals and two filters that each only interact with one visual. Ideally I'd like to fit it all in one visual.
My data is formatted as two columns, a source column and a destination column. I've got a lot of other information associated with the moves (type of event, job titles for each, department) but I don't think it's relevant for the Sankey.
1 Reply
To create a multilevel Sankey visual in Power BI that displays internal mobility within the organization, you can use the Sankey visual and apply appropriate filters. However, the Sankey visual in Power BI does not support multiple levels out of the box. You mentioned that you have tried using two separate Sankey visuals and two filters to achieve your goal. While this approach can work, it may not be ideal if you want to fit everything into one visual.
One alternative approach is to use custom visuals available in the Power BI marketplace. There are several custom visuals that offer enhanced Sankey chart capabilities, including support for multiple levels. You can explore the marketplace to find a custom visual that meets your requirements.
Another option is to consider using other visualization tools or programming languages that provide more flexibility and customization options for creating multilevel Sankey visuals.
If you find this insightful, please provide a Kudo and accept this as a solution.
