Multi level sankey chart over time

[hyattt]

Hello all, I have looked at the posts that are out there for multi-level sankey and I am still having issues getting my sankey to work. Below is the data that shows the counts of student majors as they progress over 5 years. The objective is to have a pillar for each year that shows the majors. MAJR1 is year 1, MAJR2 is year 2 and so on... I am starting with only one major EESC, and showing the progression through the 5 years.

I created the following in Modeling for the first two years as my initial attempt at this...

Table =

UNION(

SUMMARIZE(

SELECTCOLUMNS('Sheet1',"Source",'Sheet1'[MAJR1],"Target",'Sheet1'[MAJR2]),

[Source],

[Target],

"StuCnt", SUM(Sheet1[STUCNT])

),

SUMMARIZE(

SELECTCOLUMNS('Sheet1',"Source",'Sheet1'[MAJR2],"Target",'Sheet1'[MAJR3]),

[Source],

[Target],

"StuCnt", SUM(Sheet1[STUCNT])

)

)

This is what the above produced... Not exactly what I was looking for.

[hyattt]

Thanks for the links, I had looked at the second one but the first one made me wonder why they used Y and N in the first pillar and Yes and No in the second. Which led me to think I needed to put number infront of my values. So all the values in MAJR1 have a 1 in front and MAJR2 have a 2 infront and so on. I think the pillar methodology doesn't work when you have the same values in Source and Target. I get the following now which is correct but I would like to have the header display without the numbers in front.

[Anonymous]

Hi @hyattt ,

In order to provide you a suitable solution, could you please share some raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples? By the way, are the numbers (1, 2, 3, 4, 5) in front of MAJR1 and MAJR2 in the data itself, or are they added later? It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[Anonymous]

Hi  @hyattt ,

Please review the following links, hope the solution in these threads can help you resolve the problem.

Multi-level sankey query - creating supporting visuals

How to create multi-level sankey diagram. Sankey visual 3.0.3

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards