Sankey fields and settings

    Every field well and every setting in the format pane of version 1.0.0.0, read from the package you download. The internal names in grey are what a PBIR file or a report-authoring agent uses. Which features need a licence is on the Sankey page; every setting works in edit mode with or without one.

    9 fields · 17 cards · 184 settings Markdown for AI assistantscatalog.json

    Fields

    FieldTakesNeededWhat it is for
    SourcesourceColumnOptionalWhere a flow starts. Use with Destination when your table holds pairs (any depth).
    DestinationdestinationColumnOptionalWhere a flow goes. A node can be a destination and a source: the visual builds the levels.
    Stages (in order)stagesColumnOptional · up to 10A flat table: one column per stage, left to right (channel, first order, status). No reshaping needed. Up to 10 stages.
    AmountamountMeasureOptionalThe size of each flow. Without it, flows count rows.
    Compare With (Premium)compareAmountMeasureOptionalBudget, prior period or scenario. Shows what changed per flow (Premium).
    Period (Premium)periodColumnOptionalA date or period column. With one stage it draws an alluvial over time; otherwise it compares the latest two periods (Premium).
    Split By (Premium)splitColumnOptionalOne small Sankey per value, same colors and order in every panel (Premium). Bind a hierarchy (Region, Country) to drill the panels down.
    Color BycolorByColumnOptionalColors nodes by this attribute (region, type) instead of by node name.
    TooltipstooltipsMeasureOptional · up to 5Extra fields for the tooltip.

    Flowflow

    SettingType and options
    Data Shapemode
    • Automatic auto
    • Pairs (Source and Destination) pairs
    • Flat Table (Stages) journey
    • Before and After (Premium) migration
    Orientationorientation
    • Left to Right horizontal
    • Top to Bottom vertical
    Align Nodesalign
    • From the Start left
    • To the End right
    • Endpoints at the End justify
    Blank StagesblankStages
    • Skip the Stage skip
    • Show as (Blank) blank
    • End the Path end
    Loopsloops
    • Draw as Arcs arcs
    • Hide hide
    Period Field DrawsperiodUse
    • Automatic auto
    • Alluvial Over Time alluvial
    • Comparison of Two Periods compare
    Show Zero FlowsshowZeroOn / off
    Finance Mode: Losses for Negative Values (Premium)financeOn / off

    Nodesnodes

    SettingType and options
    Color Nodes BycolorMode
    • Node Name (Stable) name
    • Column level
    • One Color single
    Node ColorsingleColorColour
    Color RuleruleColour
    Node Width (0 = Theme)widthNumber
    Node SpacingspacingNumber
    Corner Radius (-1 = Theme)cornerRadiusNumber
    Order Nodessort
    • Fewest Crossings smart
    • Largest First value
    • A to Z az
    • Data Order data
    • Custom (Drag) custom
    Show Top N per Column, 0 = All (Premium)topNNumber
    Merge Nodes Below % of Column (Premium)minNodePctNumber
    Other LabelotherLabelText
    Drop-Off and Entry Nodes (Premium)balanceOn / off

    Node ColorsnodeColors

    SettingType and options
    Node Color 1c0Colour
    Node Color 2c1Colour
    Node Color 3c2Colour
    Node Color 4c3Colour
    Node Color 5c4Colour
    Node Color 6c5Colour
    Node Color 7c6Colour
    Node Color 8c7Colour
    Node Color 9c8Colour
    Node Color 10c9Colour
    Node Color 11c10Colour
    Node Color 12c11Colour
    Node Color 13c12Colour
    Node Color 14c13Colour
    Node Color 15c14Colour
    Node Color 16c15Colour
    Node Color 17c16Colour
    Node Color 18c17Colour
    Node Color 19c18Colour
    Node Color 20c19Colour
    Node Color 21c20Colour
    Node Color 22c21Colour
    Node Color 23c22Colour
    Node Color 24c23Colour
    Node Color 25c24Colour
    Node Color 26c25Colour
    Node Color 27c26Colour
    Node Color 28c27Colour
    Node Color 29c28Colour
    Node Color 30c29Colour

    Node IconsnodeIcons

    SettingType and options
    Node Icon 1i0
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 2i1
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 3i2
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 4i3
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 5i4
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 6i5
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 7i6
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 8i7
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 9i8
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 10i9
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 11i10
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 12i11
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 13i12
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 14i13
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 15i14
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 16i15
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 17i16
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 18i17
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 19i18
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 20i19
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 21i20
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 22i21
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 23i22
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 24i23
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 25i24
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 26i25
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 27i26
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 28i27
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 29i28
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check
    Node Icon 30i29
    • None none
    • Factory factory
    • Lightning bolt
    • Sun sun
    • Flame flame
    • Water Drop water
    • Leaf leaf
    • Person user
    • People users
    • Cart cart
    • Store store
    • Truck truck
    • Box box
    • Gear gear
    • Coin coin
    • Globe globe
    • Building building
    • Heart heart
    • Star star
    • Flag flag
    • Check check

    Annotationsannotations

    SettingType and options
    Note 1a0Text
    Note 2a1Text
    Note 3a2Text
    Note 4a3Text
    Note 5a4Text
    Note 6a5Text
    Note 7a6Text
    Note 8a7Text
    Note 9a8Text
    Note 10a9Text
    Note 11a10Text
    Note 12a11Text
    Note 13a12Text
    Note 14a13Text
    Note 15a14Text
    Note 16a15Text
    Note 17a16Text
    Note 18a17Text
    Note 19a18Text
    Note 20a19Text
    Note 21a20Text
    Note 22a21Text
    Note 23a22Text
    Note 24a23Text
    Note 25a24Text
    Note 26a25Text
    Note 27a26Text
    Note 28a27Text
    Note 29a28Text
    Note 30a29Text

    Node LabelsnodeLabels

    SettingType and options
    ShowshowOn / off
    NamenameOn / off
    ValuevalueOn / off
    PercentagepercentOn / off
    Percentage OfpercentBasis
    • Total total
    • Column level
    • Largest Source source
    • Inflow vs Size incoming
    FontfontFamily
    • Inter inter
    • Segoe UI segoe
    • Arial arial
    • Georgia georgia
    Text SizefontSizeNumber
    BoldboldOn / off
    ItalicitalicOn / off
    UnderlineunderlineOn / off
    Name ColorcolorColour
    Value ColorvalueColorColour
    Display Unitsunits
    • Auto auto
    • None none
    • Thousands K
    • Millions M
    • Billions B
    Decimals (-1 = Auto)decimalsNumber

    Link LabelslinkLabels

    SettingType and options
    ShowshowOn / off
    ValuevalueOn / off
    Percentage of SourcepercentOn / off

    Column Headersheaders

    SettingType and options
    ShowshowOn / off
    FontfontFamily
    • Inter inter
    • Segoe UI segoe
    • Arial arial
    • Georgia georgia
    Text SizefontSizeNumber
    BoldboldOn / off
    ItalicitalicOn / off
    UnderlineunderlineOn / off
    ColorcolorColour
    Column 1 Headerh0Text
    Column 2 Headerh1Text
    Column 3 Headerh2Text
    Column 4 Headerh3Text
    Column 5 Headerh4Text
    Column 6 Headerh5Text
    Column 7 Headerh6Text
    Column 8 Headerh7Text
    Column 9 Headerh8Text
    Column 10 Headerh9Text

    Compare (Premium)compare

    SettingType and options
    CompareenabledOn / off
    Current Period (Empty = Latest)currentPeriodText
    Compare With Period (Empty = Previous)comparisonPeriodText
    Count as Unchanged Below %flatBandNumber
    Biggest Changes StripstripOn / off
    Show Lost Flows (Dashed)showLostOn / off

    Small Multiples (Premium)smallMultiples

    SettingType and options
    Columns (0 = Auto)columnsNumber
    Same Scale in Every PanelsharedScaleOn / off

    Insights (Premium)insights

    SettingType and options
    Show InsightsshowOn / off
    Number of SentencescountNumber

    Interactioninteraction

    SettingType and options
    Trace Paths on Hover and ClicktraceOn / off
    Dimmed Opacity %dimNumber
    Drag NodesdragOn / off
    Reset Dragged PositionsresetLayoutOn / off
    Data Table ButtontableButtonOn / off
    Double-Click Collapses Downstream (Premium)expandOn / off
    Trace Exact Volume Shares in Journeys (Premium)volumeTraceOn / off
    Export Button (Premium)exportButtonOn / off
    Export FormatexportFormat
    • Excel Workbook xlsx
    • CSV csv

    Themetheme

    SettingType and options
    ThemeselectedTheme
    • SmartVisuals smartvisuals
    • Dark dark
    • Clean (White) clean
    • Slate slate
    Use Report Theme ColorsreportColorsOn / off
    Transparent BackgroundtransparentBgOn / off
    Background ColorbgColorColour

    Accessibilityaccessibility

    SettingType and options
    Focus Outline ColorfocusColorColour
    Focus Outline WidthfocusWidthNumber
    Minimum Text SizeminFontSizeNumber
    Reduce MotionreduceMotionOn / off
    Patterns for States (Non-Color Cue)patternsOn / off

    Style TemplatestyleTemplate

    SettingType and options
    This Visual's Style Code (Copy)copyText
    Paste a Style Code to ApplypasteText

    Statestate

    SettingType and options
    PositionspositionsText
    OrderorderText
    Color MemorycolorMemoryText
    Color KeyscolorKeysText

    Setting a value in PBIR

    In a visual.json, a setting goes under visual.objects, by card and internal name. Toggles take true or false, choices and text a value in single quotes ('auto'), numbers a D suffix (12D).

    "visual": {
      "visualType": "smartVisualsSankey7C41D2E09B8A4F6E9D3A51C2B7E04F18",
      "objects": {
        "flow": [{
          "properties": {
            "showZero": { "expr": { "Literal": { "Value": "true" } } }
          }
        }]
      }
    }