Forum Discussion
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 | Department |
| Alan | I01 | 2 | B |
| Alan | I01 | 3 | B |
| Boaz | I02 | 2 | C |
| Caleb | I03 | 2 | C |
| Caleb | I03 | 3 | D |
| Donald | I04 | 2 | A |
Sample Output:
Expectations:
1. Organisation Levels
2. Departments at each level
3. Count of Employees moving between departments and levels.
Please help!
Thanks!
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.
8 Replies
- GeraldGEmerick
Memorable Member
Feba You are missing a column such as an Index column or Date column to define which row comes "first" but you could do something like the following:
Level 1 = COUNTROWS( 'Data' ) Level 2 = COUNTROWS( FILTER( 'Data', [Organisational Level] = 2 ) ) Level 3 = COUNTROWS( FILTER( 'Data', [Organisational Level] = 3 ) )Thanks for your response GeraldGEmerick !
I am still unclear if there are any visuals that support/can be used for my use case.
List of visuals I have tried using (unsucessfully):
1. Hierarchy chart2. Sankey Chart
3. Decomposition Tree
4. Matrix
The flow of data between Departments and levels are not supported at the same time.- GeraldGEmerick
v-veshwara-msftCommunity Support
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.
- v-veshwara-msft
Hi Feba ,
Just wanted to check if the responses provided were helpful. If further assistance is needed, please reach out.
Thank you. 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
Hi Feba ,
Thanks for the update.Please keep us posted once you have more details or if further assistance is needed.
V-yubandi-msftHi Feba ,
As we haven’t heard back from you, please share any updates and let us know if you need any additional details.
