How to reset the position of nodes in Sankey visual?

[NelsonTan]

Hi All

I'm happy with using the Sankey visual (3.0.3) so far, however if I move the node vertically/horizontally, I can't seem to undo this to its default position. Is there is a way/trick to reset this to default without manually moving the nodes?

If I move the nodes manually, the visual doesn't render properly with new data, i.e. the nodes are all over the place.

I could set up a new Sankey visual every time I face this issue, but this solution is not sustainable.

Thanks

[mike_honey]

I bumped into this issue today, and found a workaround.

1. Save the PBIX in PBIP format (without PBIR format enabled)

2. Open the report.json file (in the zzz.report subfolder)

3. Find the sankey visual, and near the end of it's node find the nodepositions section.  Carefully delete that section (json format is very weird, example below).

4. reopen PBIP using Power BI Desktop, and your Sankey visual layout should be reset.  Save as PBIX if you prefer. 

Node position changes only seem to stick in Power BI Desktop, presumably because a view-only Power BI web user cannot update the report definition.  In Power BI web, a refresh of the browser seems to reset the layout.

[Anonymous]

Hi  @NelsonTan  ,

For the content of Sankey diagram and mobile node, you can check the following links, hoping to help you:

https://community.powerbi.com/t5/Desktop/Sankey-Diagram-Moving-node-positions/td-p/77858

https://www.mssqltips.com/sqlservertip/5288/analyze-entity-data-flow-in-power-bi-desktop-using-sanke...

For more issues about  Sankey Diagram, you can directly contact the author. In this link, you can send an email to the author by clicking “Contact Author”. 

Best Regards,

Liu Yang

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