Need Help with Sankey Chart

[Anonymous]

Hi All,

I need to show the following analysis in sankey chart, can anyone help me to achieve this in Power BI:-

Scenario:-

►When user selects their current role and their aspirational role, the visual should show skill overlaps and skill gaps.

For example, Asset Manager (11 skills) and Business Manager (10 skills) have an overlap in 6 skills:

►Analytic Ability (ET)

►Data Analysis (ET)

►Influence

►Planning and Forecasting

►Project Time Management (ET)

►Structured Problem Solving

There are 4 skills that Asset Manager needs to build to become Business Manager:

►Change management – Shared Services/Global Business Services (ET)

►IT Decisions and Authorizations

►Financial Planning, Budgeting, Forecasting and Management Accounting Process Knowledge

►C-level presentation

Please find the visual and link to samle data:-

https://docs.google.com/spreadsheets/d/1TbWId-ZvTvHudYwyfIWdjrVxNVSDx-MCpLlXcel0Av8/edit#gid=0

Regards,

Harish

[lbendlin]

One approach would be to use a binary decision tree

- skills that match - 1

- skills I have but not required in new role - 2

- skills I need - 4

and then add them up.

But it's really up to you to decide what is important to you in this particular scenario.

[Anonymous]

Thank you @lbendlin for your help, I will have some logic created with the idea given.

[lbendlin · Accepted solution]

You are using the wrong visual.  A matrix visual with conditional formatting would work better but you need to find one that allows for vertical column header text.

If you play with the weighting you can even end up with a visual that spells out exactly which skills are still needed.

[Anonymous]

@lbendlin Thanks for giving me an alternate solution, this helps and all this while I was just glued to achieving this in sankey chart. I just want a visual to tell the story irrespective of which visual I use, could you please help me with the weights if possible.. I am not sure how to achieve that!!