Multilevel Sankey Chart with fixed order

[AndrejZitnay]

Hello all,

I am trying to build Multilevel Sankey Chart with fixed order.
My problem is that I can't apply Hierarchy.

My dataset is simple :

Employee	Manager	Employee Level	Manager Level
Link	Ondo	6	3
Kolpak	Ondo	6	3
Kolpak	Ondo	6	3
Lihsin	Elza	6	2
Lihsin	Elza	6	2
Masit	Elza	6	2
Smith	Pam	6	6
Smith	Pam	6	6
Moul	Rick	2	1
Moul	Rick	2	1
Ondo	Moul	3	2
Kat	Moul	6	2
Neol	Moul	4	2
Neol	Moul	4	2
Neol	Moul	4	2
Pina	Moul	6	2
Farah	Moul	3	2
Pam	Farah	6	3
Efrey	Farah	6	3
Bred	Farah	6	3
Bred	Farah	6	3
Lent	Farah	6	3
Maria	Farah	6	3
Moto	Farah	3	3
Klara	Pina	6	6
Crystal	Neol	5	4
Atol	Neol	5	4
Atol	Neol	5	4
Barry	Atol	6	5
Barry	Atol	6	5
Mary	Linda	6	4

This is my outcome from Sankey Chart.

Manager Level is very importnat for me.

Desired Outcome by Manager

At least first 5 leveles needs to be fixed

Is this possible?

I don't mind to use some other visual but I need to achive similiar outocme. 

Many thanks in advance for any help.

Andrej

[v-junyant-msft]

Hi @AndrejZitnay ,

Thanks for @rajendraongole1's reply!
Unfortunately, Sankey Chart does not have this functionality at the moment. I have tried a few other default and custom visuals, but have not found one that does what you want.
I can provide you with a workaround. I suggest you check this option in File > Options and settings > Options > CURRENT FILE > Report settings:

Then manually drag your existing Sankey Chart to the desired result you want to achieve, and save and publish it. When other users open the report, the visual object will be displayed by default after your manual changes, and any operations they make will not be saved. The next time you open the report, it will still be restored to the state after your manual changes.
Solved: Locking sankey nodes for sharepoint purpose - Microsoft Fabric Community

Or you can try exploring more custom visual objects and perhaps find an alternative that you are satisfied with.

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

[rajendraongole1]

Hi @AndrejZitnay  - Power BI’s default Sankey chart does not support hierarchical ordering directly.

can you please try custom visuals like:

• Deneb (highly customizable for hierarchical visualizations)
• MAQ Software Sankey Chart
• Sankey Chart by OKViz

Multi-Level Sankey diagram in Power BI using DAX | Sankey Chart Custom Visual

Hope this helps.