Microsoft Sankey Visual: How can I prevent destination nodes being automatically reordered?
Hi all, I'm using the Microsoft Sankey visual in Power BI Desktop and would like to keep the node order consistent between the left and right sides of the chart. My source data is structured as: From To Value Apples Apples 45 Apples Pears 7 Pears Fig 26 Fig Cherry 115 Cherry Cherry 13 Intended category order: Apple Pear Fig Cherry However, the Sankey visual automatically changes the order of the destination nodes presumably to reduce flow crossings. I have already tried: Creating a numeric sort column (1 = Severe, 2 = Moderate, 3 = Mild, 4 = Normal renal function) Using Sort by Column on the destination field (To) Creating a separate Category/SortOrder lookup table Sorting both the source data and lookup table correctly Disabling Auto links reorder in the visual settings Power BI accepts the sort order without errors, but the Sankey visual continues to reorder the destination nodes. Manually dragging is not ideal, as the freehand movement does not allow precision. My questions are: Does the Microsoft Sankey visual support a fixed destination node order? Is there a supported way to force the same category order on both sides of the Sankey Any advice would be greatly appreciated. Thanks!
Legend and Stacked column both in same order..has this been solved
The Column is sorting with first name in Legend on the bottom and last Name on top. Is there a way to have it sort with last name on bottom of stack and first name on top for better readability? I've tried things from other posts, but nothing works. I also saw to vote for feature, but looks like this request has been out there for years with no progress. Please help out a girl. 🙂
