Forum Discussion

Feba's avatar
Feba
Frequent Visitor
10 months ago
Solved

Help: Visualisation to view Transfer of Employees across Departments based on Organisation Level

Hi, Problem Statement: I want to be able to visualise the flow of Employees to different Departments based on their Organisational Level. Data: Employee Name EmployeeID Organisational Level...
General Comment
Need Help
  • v-veshwara-msft's avatar
    v-veshwara-msft
    10 months ago

    Hi Feba ,

    Thanks for reaching out to Microsoft Fabric Community.
    I tested this using the sample data you provided. After reshaping it to show how employees moved between departments across organisational levels, I merged Level 2 and Level 3 records by EmployeeID and created combined labels like “Level 2 - B” and “Level 3 - D.”

    Using the Sankey chart, I was able to visualise the flow between departments and levels in a single view with ribbon thickness based on the number of employees.

     

     

     

    Hope this helps. Please feel free to reach out if this doesn’t meet your requirements.

    I’ve attached the PBIX file for your reference.

    Thank you.

Feba's avatar
Feba
Frequent Visitor
10 months ago

Hi,
Thank you for your response. I understand I will need a different schema to work with.
Current limitation is that only one set of Dept/level can be viewed in a chart.
Thanks for your time! Will kep you all posted.

  • v-veshwara-msft's avatar
    v-veshwara-msft
    Icon for Community Support rankCommunity Support
    10 months ago

    Hi Feba ,
    Thanks for the update.

    Please keep us posted once you have more details or if further assistance is needed.

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Icon for Community Support rankCommunity Support
    10 months ago

    Hi Feba ,
    As we haven’t heard back from you, please share any updates and let us know if you need any additional details.