Sankey weighting not reflected accurately in visual

[wes-shen-poal]

Hi all,

When using a Sankey chart, the thickness of the ribbons does not reflect the weighting

E.g. screenshot below:

Number of counts from Port Kembla to Auckland is 2,654. From Nagoya Aichi to Auckland is over 8x of that. Yet in the visualisation, the ribbon thickness is very similar thus misleading.

Is anyone else experiencing something similar? Is this a known problem and is there a solution?

Thanks in advance for your assistance,
Wes

[nikitagrachev]

@Anonymous, we're investigating the issue, after that we'll release the new version.

It would be great if you can send a sample pbix file to us. It would speed up the process.

[Anonymous]

Hi,

I have found a bunch of examples of what appears to currently break Sankeys and have sent a PBIX file containing these through to you. I think it is something to do with having your Source and Destination fields in different tables from the value your are measuring, or from each other. Although sometimes it happens and sometimes it doesn't.

Also copying a sankey in certain situations seems to break the copy. 

Chaing the fields in an exsiting sankey can appear to break it as well and it will display fields that used to be in it rather than the new fields.

[Anonymous]

Hi,

I have just sebt a PBIX and associated example Excel data file to the requested email address.

It is just some made up data data. However it is not plotting consitent with the error I am seeing elsewhere.

Kind regards,

Ben

[nikitagrachev]

Hello @Anonymous, could you please send the sample pbix file to pbicvsupport@microsoft.com?

We'll investigate the issue.

[Anonymous]

I am afraid that the data is confidential so I can't share a pbix file. However data where there is information in the service that hasn't been refreshed for a few months has broken, as have ones that are refreshed nightly.

This is also the case for multiple different sources so it would seme to be a pretty wide-spread error.

I will attempt to replicate the problem with some safe data and then send you a PBIX file.

[v-ljerr-msft]

Hi @wes-shen-poal, @1taylor,

I have reproduced this issue on my environment. I will report it internally and post back if there is any feedback. 

Regards

[1taylor]

Also, if I roll back my Power BI to the version (May) that the Sankey Diagram chart worked fine for me in (with the same data that is now not being weighed correctly), it now won't even plot it. 

[1taylor]

I am experiencing the same thing. My Sankey chart is weighing $74 million the same as a $.4 million. I've tried recreating it with updated Power BI, different excel sheet, etc. and it still isn't working.