Sankey Visual Display Error

[an1908]

I'm encountering an error where the length of the Sankey doesn't match the underlying data. In the example below, the sum of complete, exit, and transfer is greater than the Enter; however, they should be equal according to the underlying data.

I'm using the below visual:

[an1908]

Thank you!!

[Anonymous · Accepted solution]

Hi @an1908 ,

Please turn off the provide min optimal height of node.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[dpilot7]

Hi everyone, I have a similar problem with my Sankey chart and I have already turned off the "provide min optimal height of node".

I have checked the values of the incoming and outcoming streams and they are correct.

The input table is the following:

Target	Source	value
A	D	1,59 €
B	D	8,67 €
C	D	0,60 €
E	H	0,15 €
F	I	6,20 €
G	I	5,00 €
I	H	11,20 €
D	H	10,86 €

Do you have any other suggestion?

Thank you in advance for your support.

[Anonymous]

Hi @dpilot7 ,

It's a little strange. My tests are fine.

What is your PBI desktop version and webview 2 version? Try updating to the latest version.

Here is my test pbix file.
We also suggest that you could start a new thread next time in case these are two different issues. You can include some links and your efforts in the new post. Thank you very much.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[dpilot7]

Hi @Anonymous ,

thanks for your feedback, using your pbix I found the issue.

You file is not using exactly my data, they are multiplied in the query by 1000 : 1,59€ is transformed in 159 and the same for the other values.

If I remove the decimal places in my files the visual is ok too.

Probably the Sankey visual has an issue to display decimal numbers.

Hope this help to fix the problem.

Best regards,

MM