Forum Discussion
Multilevel Sankey Chart with fixed order
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
2 Replies
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.
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.
