Skip to main content
Sankey Diagram is a specific type of flow diagram used to describe the flow from one set of values to another. Characteristics of Sankey diagrams:
  • Starting flow and ending flow are the same, the sum of all main branch widths equals the sum of all outgoing branch widths, maintaining energy balance;
  • Internally, different lines represent different flow distribution situations, and their widths proportionally display the flow occupied by this branch;
  • Different node widths represent flow magnitudes in specific states.
There are two data display methods for creating Sankey diagrams:
  • Flow relationships between multiple dimensions.
  • Flow relationships of a dimension hierarchy.

Between Multiple Dimensions

Select the chart type as Sankey Diagram (Sankey), and set one measure and multiple dimensions. Small This method displays measure relationships between different dimension members. Middle Shadow

Chart Direction

You can set the chart’s direction property to change the Sankey diagram’s horizontal or vertical display.

Single Dimension Hierarchy

You can also set only one hierarchical measure for the Sankey diagram display. Select a dimension, select the finest level to display and set its property Include Parent Levels, and the data will calculate hierarchical data for this level and all its parent members. Small Sankey diagram displaying hierarchy:

Containing All Members

This function checks if the hierarchical structure already contains an All member. If it does, you can set the Contains All Members property in the Series Styles of the Sankey diagram, and the Sankey diagram will not add a new All node. Otherwise, the Sankey diagram will automatically add an All node to the data.

示例