Forum Discussion
Help: Visualisation to view Transfer of Employees across Departments based on Organisation Level
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.
Memorable MemberFeba 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 chart
2. Sankey Chart
3. Decomposition Tree
4. Matrix
The flow of data between Departments and levels are not supported at the same time.
- GeraldGEmerick