students migration by multi-level sankey graph

Hi juddin ,

When creating a Sankey diagram in Power BI, you need to prepare a data table that contains these fields. For example, if you are tracking students' major migration, your data table might need to contain the students' IDs, their original majors (source), the majors they transferred into (destination), and the number of students who migrated in each semester (weight).

I did the following with the data you provided and create below measure, then created a Sankey chart based on it.

Migration Weight = COUNTROWS('Test')

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.