Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
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.
Hi @AndrejZitnay - Power BI’s default Sankey chart does not support hierarchical ordering directly.
can you please try custom visuals like:
Multi-Level Sankey diagram in Power BI using DAX | Sankey Chart Custom Visual
Hope this helps.
Proud to be a Super User! | |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
217 | |
89 | |
76 | |
67 | |
60 |