microsoft / powerbi-visuals-sankey

Sankey is a type of flow diagram in which the width of the series is in proportion to the quantity of the flow. Use it to find major contributions to an overall flow.

powerbi-visuals-sankey

Sankey is a type of flow diagram in which the width of the series is in proportion to the quantity of the flow. Use it to find major contributions to an overall flow.

Overview

With Sankey, you can clearly find the sources, destinations and steps in between and how the stuff flow across them all in one quick glance. You can also interact with it either by clicking the link or the flow itself and leverage the cross highlighting/filtering feature of Power BI to get even more interesting insights in related data. Fittingly they are used widely in the energy industry. But it finds interesting use cases across all industries. It energies everyone to visualize information that has a start and an end or dynamic relationship with many intermediaries, for example how the user landed and navigated in a web site, or a material in a manufacturing unit, control or money transfers in business processes in a completely different perspective and bring interesting insights to the forefront.

See also Sankey at Microsoft Office store

Documentation

Check out documentation to find out more about visual's properties and features

Sankey visual

powerbi-visuals-sankey's Issues

Sankey diagram not fully visible

Hi,

in some cases the sankey diagram is not fully visible. Can you please check the attached screenshot. Is there any workaround for this problem?

Power BI Version 2.65.5313.701 64 Bit December 2018
Chart Version 1.10.0.0 Relaease Date 19.3.2017 (actual Version from store)

Best regards,

Alex

Sort order

we have noticed that you are unable to sort either the source or destination on the diagram. It would be useful to be able to sort by A-Z particularly if using named areas, and trying to see the change of the flow over different time points when using a filter. At the moment as i change time period on the slicer, area names will completely move placement, even though they are still present making it more difficult to see how the time period effects the flow

Nodes overlap and change colors when selecting new slicer value

I am able to create the Sankey chart and use a slicer to filter the data. However, once I select a different value for the slicer, the nodes of the Sankey chart all overlap, are not formatted correctly, and sometimes change the set color. I am able to manually adjust the nodes so they do not overlap after selecting a new slicer, however, I have over 700 values for the slicer and it is not feasible to go through each one and manually re-adjust the nodes so they do not overlap.

Consistent colors

The biggest issue for us is lack of consistent colors. I can set the colors of the ribbons very easily, but as soon as I drill down, the ribbon color remains but the color of the bar changes. Can the color settings of the ribbons and the bars be tied?

Show position of node as it's being dragged

Drag & drop is great but it's tricky to get the nodes lined up correctly if you can't see where it is until you drop it.

Allow Measures for Source and Destination

I have a date range filter and I want to see just two states for each item. In this case, I have projects and I want to see their start state and end state in any arbitrary period. I have a table with each project's status on each day. Start states are New or Carry Over and end states are Complete or Carry Over. I want to see flow for each path.

The way to show this start and end state would be through using a measure to find the first and last state for each item in the filtered date range, but measures can't be used in the source or destination fields.

Using measures for source and destination shouldn't have any ill effects for 2 state diagrams. Measures can't create a 3 state diagram anyway.

Add support for cycles

Suppose your data set has a cycle, such as A->B and B->A. The current sankey visual will render it as:

But ideally the visual would not render the same node twice, but instead represent the cycle as another path between the nodes (perhaps with a different color, as done here.

The current behavior makes the visual pretty much unusable when you have cycles, as it is too confusing for users to deal with the same node being drawn multiple times.

Ordering of elements

Hi all,
I've been playing around with this SanKey diagram and have discovered that it is an excellent way to clearly visualise complex flow patterns.
One thing I believe needs to be added is the ability to reorder the columns of sources/destinations, either alphabetically or by dragging the elements once the diagram is drawn.
Is this something that could be considered for future releases?
This functionality includes in the similar visual created by Brad Sarsfield, but that one doesn't have the functionality where you can click and highlight paths or elements and have other visualisations filtered by that selection.
The file I have was downloaded as version 1.0.0.0, but the file itself has references to version 0.2.0.
Thank you for considering.

HD.

Destination Labels

Hi,
The "Destination Labels" field is not available in Sankey chart version 3.0.3 (Latest version).

Screenshot:

Sankey Diagram Needs new capability

Hello,
I have rather enjoyed using the Sankey diagram for displaying cycles of information. Many of my colleagues and I would like the ability to fix the position of the data labels (at least this is what I am calling them). I am having an issue that every time I re-filter my data using a slicer, the Sankey chart changes the position of the data labels. To me, this is a major problem to an otherwise amazing visual. Is there any future consideration for this? Thank you.

Option to Highlight flow through multiple levels

I have a 4 tier flow. When I click a middle tier, I'd like to be able to see all the items related, even if I can't get the value of the flow between grandparent/grandchildren nodes.

This should be an option that can be toggled on and off.

Obligatory terribly drawn sample:

SankeyChart version in the Office store is behind current version on Github

SankeyChart version in the Office store is behind current version on Github

Sankey diagram runtime update

I can get Sankey diagram linked with fixed cells in excel/csv data (static).
Now, from drop down menu in same excel file, if I select another case the data of fixed cells are changing in excel but the linked Sankey diagram is not changing.
Can you suggest how to update Sankey diagram while changing the other case data?

SankeyChart visual can only display data from CSV

As in the title, when the data is pulled from a SQL Server data source, the visual stays blank and doesn't display anything. This is a recent development and the same issue happens with an older version as well as the latest version on the Office store (1.0.0.0). When the same data is exported to a CSV and then imported to Power BI, the visual displays in Power BI Desktop.

Power BI Desktop versions tried are May, June and July 2017.

In the Power BI service, the visual was working before and now has stopped displaying anything. It just displays a blank tile with a title.

This repo is missing important files

There are important files that Microsoft projects should all have that are not present in this repository. A pull request has been opened to add the missing file(s). When the pr is merged this issue will be closed automatically.

Microsoft teams can learn more about this effort and share feedback within the open source guidance available internally.

Merge this pull request

Add fields to tooltip

In most visuals, there's a spot to put additional stuff in the tooltip. I don't see this on the sankey viz. For example, I have a short, summary name, to show on the chart, and want to put the full name and description in the tooltip.

Ability to define a "key field" and track records through whole visual

We use this visual to show equipment swaps and customer activity during a month, and it's great for seeing the volume of customers that moved through a specific activity. If I click on a flow or a gate, I can see the customers that went through that step and where they came from/went to.

I'd like to be able to define a "key field" for the visual (the customer account number, for example) so that when I click on a flow, the visual can highlight that group of customers all the way to the beginning and the end of the flow, showing me their entire lifecycle. The current highlighting/filtering is great, I just want the ability to extend it beyond the current stage.

Thanks for your work on a great visual!

visual not displaying on web

I have been using Sankey for over 4 months, but today I noticed that the chart is blocked in the web version. The error message is "This content is blocked. Contact the site owner to fix the issue". When I inspect the visual on the web, I encounter this error message "Refused to display 'https://app.powerbi.com/' in a frame. The embedder requires it to enforce the following Content Security Policy: 'default-src https://app.powerbi.com data: blob: 'unsafe-inline' 'unsafe-eval' ;'. However, the frame neither accepts that policy using the Allow-CSP-From header nor delivers a Content Security Policy which is at least as strong as that one."

Nice to have: customizable bar colors

We'd like to color code our groups so that each one is identified by the same color across all reports, making it easy for them to spot their figures in charts.

Can the Sankey allow the colors of the bars to be set too? Ideally users would have an option to make the bars & ribbon colors match, but default would be black ribbons.

Change colors of links by value

Dear PowerBI team,
Consider a dataset with two value columns per row, for example:
Producer | Consumer | Quantity |Price

While the sankey currently can perfectly demonstrate the first 3 columns (as source, destination, weight) it would be great to be able to visualise the price using a colour palette, gradients in a reproducible way.

The option to colour individually the link already exists

Thanks

enable Drillthrough for multi-level Sankey

Hi,
I've made a multi-level sankey and am trying to add supporting visuals for the visual. I added an index column in power Query. However, it looks like the Sankey visual does not support drillthrough. Is this something that may be added?

Thank you!

All the best,
Andrew

Allow for more whitespace

I'm new to PowerBI and I just discovered this visualisation - it's awesome, thankyou for publishing it!

One issue I have is that my visualisation is quite "busy" and I'd like to be able to resize the canvas to give myself more space to drag the nodes around within. Right now, if I resize the control on the report page, the contents resize too, so I can't get any more whitespace.

Destination labels

Hi, add your wonderfull plugin from Power BI's AppSource, but the destination labels doesn't show, only source labels do. Is this an issue? or it is the properly behaviour in the new release?

(It's in spanish, sorry ;) )

Thanks!!

Inherited link colours

It would be really useful to have an option for each link to inherit the colour of either it's source, or it's destination. Otherwise the only other option is to set the colour manually for each link, which often ends up being a huge list. Furthermore when the data changes the colours of the source/destination boxes also change which means that any colours you do set in this way are now wrong.

Option to select display units.

An option to be able to select the display units would be very helpful. Currently it looks automatic. If one bar is £4000 it comes up as £4.00k... Unfortunately that means a bar with a value of £3 shows as £0.00k
Thanks. :)

Feature request: allow displaying weight values on links

Please support displaying weight values on links -- the soul of Sankey diagrams is to show the linkage between nodes and the weight (how much is transferring between nodes) —

Yes there is a Data link labels option, however it adds not only weight values but also all node names, so once turned on the visual becomes very cluttered. Also a bug here is although data field Amount is set to Currency format with 2 decimal places, the shown values in data link labels are still not like $1,630.00 —

A suggestion is to merge Data label and Data link labels into a new Data label option, and add toggle controls under it to allow the users to individually turn on/off Source/Destination/Weight labels. This way turning on Weight only achieves what is been asked for in the caption (many users will love it...), while turning on all three is equivalent to turning on today's Data link labels (viable only for uncluttered simple/small charts).

Thank you for considering this feature request and fixing the mentioned bug.

Flow of the visual diagram is not as the data suggests

We have the following data:

Source	Destination	Count
msftmfg	#cloud	        13
msftmfg	#security	        9
#security	peter	        6
#cloud	john	                3

However, the graphical representation is shown as in the picture.

Which is confusing. The problems we see are:

• msftmfg is never present in the Destination field yet the visual shows it as destination
• peter and john are never present in the Source field yet they are the sources in the visual

Our expectation is that the visual starts from msftmfg goes through #security and #cloud and ends with peter and john.

Sankey is not always refreshing in the July PowerBI Desktop Release

We've been using the Sankey for a few weeks now and its really great. It seems that our team as well as other customers are having issues getting the Sankey to refresh after making a selection change in our slicers. It seems to be totally random as to when it will update the Sankey after making a change in the Slicers.
Take a look at the reviews on the Office Store site.
https://store.office.com/en-us/app.aspx?assetid=WA104380777&ui=en-US&rs=en-US&ad=US&appredirect=false

Tool-tip functionality

Being able to add a tool-tip field (much like with the default charts) would be helpful.

For example, you might want to visualise the flow of value through a factory process, but also be able to hover over the bars to see the physical quantity of items used (some may be worth far more or less per unit).

Change Colors of labels

Hi guys,
it would be extremly great if it was possible to change the individual (background) colors of the data labels. Right now its only possible to change the color of the data label text and the data links.

Best regards

Tooltip values for weights at nodes

Hi,

I have downloaded and am using SankeyDiagram.SankeyDiagram1446463184954.2.0.1.0. I have created the diagram, but when the mouse hovers over the node labels, the tooltip shows a different (and incorrect) weight than when hovering over the link.

I have worked out that this is because when hovering over the node, the tooltip sums up all of the weights EXCEPT the weight where the relationship is NODE A -> NODE A.

To elaborate, if I have data such as :

Source Destination Weight
USA USA 5
USA UK 1
USA Germany 1

When hovering over the USA source node, the weight will be given as 2 instead of 7. Is there a way to change this in the visual, or turn off the tooltip?

Any help much apprciated.

When slicing down to 0 the visual shows all the flows incorrectly at value of 1 when they are 0

When slicing down to 0 the visual shows all the flows incorrectly at value of 1 when they are 0. When using show as a table, every source and destination shows a count of 0 which is correct in this edge case. In v2.1.3 of the Sankey diagram on a different report, the visual is blank when we slice down to 0, however this one shows flows of 1 across the board which is incorrect. Also we noticed that tabular has a formatting of show thousands separator for the count measure but that does not show in the tooltip as it does in the previous version. If I add a local measure (instead of tabular) it slices properly.

Is the clusterization wanted?

Hi,

we're using this visual because it's great! Just one question. I noticed an initial clusterization between the nodes:

Is it wanted? If so, what's the logic behind this way of clustering?

Thank you

Data privacy question

Hello! Thanks for making this, I love that you can drag the bars around!

I had a quick question re. the following on the Microsoft app store. Apparently the app:
"Can send data over the Internet". After a quick skim through the code, I couldn't see anything obvious - what data can it send over the internet? It seems to be a general warning for everything but I was hoping for some clarity!

Thank you

Sankey displaying nulls

Hi,

I'm using the Sankey Chart in Power BI, and it's using the null values as a target and displaying them as a category. How can I avoid this? I want the source page to be displayed even if it doesn't hit any target, but without displaying the nulls as a category in the Targets.

I would greatly appreciate your help.

Thank you!

Data labels not displaying in full

Hi all, the data labels cannot be customised to fit in the diagram? Even with the smaller possible font, the customisation is not feasible

Visual not displaying in Power BI Report Server

Hi,

The visual works perfectly in Power BI Desktop, but after uploading to Power BI Report server it becomes invisible.

Any help or suggestion?

Thank you.

Some aspects too small to show

It would be nice to be able to force item labels to appear, even if the bar is very small.

You can also see below that some lines are too small to be visible. Perhaps an option to be able to specify a minimum width would be useful... Or a dotted line could be used when the line gets to a certain thinness.

(I've actually flipped my source and destination because it shows everything more clearly)

Link and nodes wrong scale

Hi,

In both desktop and online, scaling of nodes and links is incorrect. See example below. Is a fix on its way?