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

[Feba]

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!

[GeraldGEmerick]

@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 ) )

[Feba]

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]

@Feba I used the Ribbon chart visual for this:

[v-veshwara-msft]

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.