Org Chart fields and settings

    Every field well and every setting in the format pane of version 1.0.1.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 Org Chart page; every setting works in edit mode with or without one.

    20 fields · 20 cards · 161 settings Markdown for AI assistantscatalog.json

    Fields

    FieldTakesNeededWhat it is for
    Employee IDemployeeIdColumnOptionalUnique id per person. Any type: numbers, codes, emails. The chart is built by matching Manager ID to this.
    Position IDpositionIdColumnOptionalOptional. Builds the chart over positions: people sharing a Position ID share one card (job share), a position with no Employee ID is an open position, one person may hold several positions.
    Manager IDmanagerIdColumnOptionalThe Employee ID of the person's manager. Blank = top of the organisation. Unknown ids are grouped under Unassigned and explained, never an error.
    NamenameColumnOptionalCard headline.
    Job TitletitleColumnOptionalSecond line on the card.
    DepartmentgroupColumnOptionalColours the cards and fills the legend; shown on detailed cards.
    Photo (Data URI)photoColumnOptional · up to 5A base64 data-URI column (data:image/...). Up to five columns are joined in well order for photos longer than one text value. No external image calls - the visual stays certifiable. Initials are shown when empty.
    EmailemailColumnOptionalWork e-mail. Adds Chat in Teams and Email to the card actions and is searchable. Links open only on a click.
    Profile URLprofileUrlColumnOptionalAn https link to the person's profile (HR system, intranet). Adds Open profile to the card actions.
    Extra Card LineslinesColumnOptional · up to 3Up to two more text fields on detailed cards (location, email, cost centre).
    Color BycolorByColumnOptionalOverrides Department as the colour key.
    Sort KeysortKeyColumnOptionalOrder of reports under the same manager. Numbers sort numerically.
    Dotted-Line Manager IDdottedManagerIdColumnOptionalA secondary reporting line, drawn dashed. Does not change roll-ups.
    Card TypecardTypeColumnOptionalemployee (default), vacancy, assistant or contractor. Vacancies draw as open-position cards and count separately.
    Snapshot DatesnapshotColumnOptionalBind when the table holds several snapshots of the organisation. The newest renders; with two, joiners, leavers and moves are highlighted (Premium).
    ValuesvaluesMeasureOptional · up to 4Numbers per person (FTE, cost, open requisitions). Shown on the card and rolled up through the tree (Premium).
    Plan ValuesplansMeasureOptional · up to 4Targets paired with Values by position (1st plan with 1st value): plan vs actual variance on every card (Premium).
    CompositioncompositionColumnOptionalA category (gender, contract type, grade, location) drawn as a 100% bar of each team (Premium).
    BadgesbadgesColumnOptional · up to 4Up to four flag columns (key person, flight risk, successor ready). yes / true / 1 / x shows the badge.
    TooltipstooltipsMeasureOptional · up to 8Extra fields for the tooltip.

    Hierarchyhierarchy

    SettingType and options
    Employees Whose Manager Is Missingorphans
    • Group Under "Unassigned" unassigned
    • Show as Separate Trees roots
    Match IDs Ignoring CasecaseInsensitiveIdsOn / off
    Order Reports BysiblingOrder
    • Sort Key, Then Name sortKey
    • Name name
    • Data Order data
    Levels Open by DefaultautoExpandLevelsNumber
    Stack Teams of at Least (0 = Never)stackLeavesFromNumber
    Stacked Team ColumnsstackColumnsNumber
    Manager ID HoldsmanagerRefersTo
    • The Manager's Position ID position
    • The Manager's Employee ID employee
    Assistants Beside Their ManagerassistantSlotOn / off
    Fold Teams of at Least (0 = Never)foldTeamsFromNumber
    Group Siblings BygroupBy
    • Nothing none
    • Department department
    • Color By Field colorBy
    ShowviewMode
    • People people
    • Org Units (Premium) units

    Cardscards

    SettingType and options
    Card Sizedensity
    • Compact (Name Only) compact
    • Standard standard
    • Detailed (Group and Extra Lines) detailed
    Photo or InitialsshowPhotosOn / off
    Job TitleshowTitleOn / off
    Department Line (Detailed Cards)showGroupOn / off
    Extra Card Lines (Detailed Cards)showLinesOn / off
    Direct Reports CountshowDirectCountOn / off
    Expand / Collapse ButtonsshowExpandChipsOn / off
    FontfontFamily
    • Inter inter
    • Segoe UI segoe
    • Arial arial
    • Georgia georgia
    Font SizefontSizeNumber
    Chip LabelschipLabels
    • Short Field Names short
    • Numbers Only off
    • Full Labels full

    Card StylecardStyle

    SettingType and options
    Card Fill (empty = theme)fillColorColour
    Border Color (empty = theme)borderColorColour
    Custom ShapecustomShapeOn / off
    Corner RadiuscornerRadiusNumber
    Border WidthborderWidthNumber
    ShadowshadowOn / off
    Name Color (empty = theme)nameColorColour
    Job Title Color (empty = theme)titleColorColour
    Detail Lines Color (empty = theme)detailColorColour

    Colors & Connectorscolors

    SettingType and options
    Color Cards BycolorMode
    • Department / Color Field group
    • Level in the Hierarchy depth
    • Span of Control (Premium) span
    • One Color none
    Connector StyleconnectorStyle
    • Theme Default theme
    • Right Angles elbow
    • Rounded Corners rounded
    • Straight Lines straight
    • Curves curved
    Connector LineconnectorDash
    • Solid solid
    • Dashed dashed
    • Dotted dotted
    Connector Color (empty = theme)connectorColorColour
    Connector WidthconnectorWidthNumber
    Dotted-Line ManagersshowDottedOn / off
    Dotted-Line Color (empty = theme)dottedColorColour

    Department ColorsdepartmentColors

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

    Team Compositioncomposition

    SettingType and options
    Composition Bar (Premium)showCompositionOn / off
    Bar CoverscompositionScope
    • The Direct Team team
    • Everyone Below subtree

    Composition ColorscompositionColors

    SettingType and options
    Composition Color 1k0Colour
    Composition Color 2k1Colour
    Composition Color 3k2Colour
    Composition Color 4k3Colour
    Composition Color 5k4Colour
    Composition Color 6k5Colour
    Composition Color 7k6Colour
    Composition Color 8k7Colour
    Composition Color 9k8Colour
    Composition Color 10k9Colour
    Composition Color 11k10Colour
    Composition Color 12k11Colour

    BadgesbadgeStyle

    SettingType and options
    Badge 1 Iconb0Icon
    • Flag flag
    • Star star
    • Alert alert
    • Heart heart
    • Shield shield
    • Clock clock
    Badge 1 Colorb0ColorColour
    Badge 2 Iconb1Icon
    • Flag flag
    • Star star
    • Alert alert
    • Heart heart
    • Shield shield
    • Clock clock
    Badge 2 Colorb1ColorColour
    Badge 3 Iconb2Icon
    • Flag flag
    • Star star
    • Alert alert
    • Heart heart
    • Shield shield
    • Clock clock
    Badge 3 Colorb2ColorColour
    Badge 4 Iconb3Icon
    • Flag flag
    • Star star
    • Alert alert
    • Heart heart
    • Shield shield
    • Clock clock
    Badge 4 Colorb3ColorColour
    Any Text Counts as OnanyValueOn / off

    Rules (fx)conditional

    SettingType and options
    Card FillfxFillColour
    AccentfxAccentColour
    Name ColorfxNameColour
    Job Title ColorfxTitleColour
    Chip FillfxChipColour

    Legendlegend

    SettingType and options
    Show LegendshowLegendOn / off
    PositionlegendPosition
    • Bottom Left bottomLeft
    • Bottom Right bottomRight
    • Top Left topLeft
    • Top Right topRight
    • Top Strip top
    • Bottom Strip bottom
    Font Size (0 = Card Font)legendFontSizeNumber
    Text Color (empty = theme)legendColorColour

    Layoutlayout

    SettingType and options
    Directionorientation
    • Top to Bottom topDown
    • Left to Right leftRight
    Space Between CardsgapXNumber
    Space Between LevelsgapYNumber
    Fit to Tile When Data ChangesfitOnLoadOn / off

    Navigationnavigation

    SettingType and options
    ToolbarshowToolbarOn / off
    Search BoxshowSearchOn / off
    Mini MapshowMiniMapOn / off
    Mini Map PositionminimapPosition
    • Bottom Right bottomRight
    • Bottom Left bottomLeft
    • Top Right topRight
    • Top Left topLeft
    Breadcrumb in Branch ViewshowBreadcrumbOn / off
    Slicer Selection Opens Branch ViewbranchFromSelectionOn / off
    Data Notes StripshowDiagnosticsOn / off
    Static Export Mode (PDF / PowerPoint)staticExportOn / off
    Scenario Planning (Premium)showScenariosOn / off
    Card Actions (Profile, Teams, Email)cardActionsOn / off
    Export Button (PDF, CSV)showExportOn / off
    Show as List ButtonshowListButtonOn / off

    PDF Exportexport

    SettingType and options
    LayoutpdfMode
    • Fit to One Page fit
    • Poster Tiles poster
    Paper SizepaperSize
    • A4 a4
    • A3 a3
    • A1 a1
    • Letter letter
    OrientationpaperOrientation
    • Landscape landscape
    • Portrait portrait
    Title (empty = none)pdfTitleText
    Export Date LinepdfDateOn / off

    Toolbar & Stripschrome

    SettingType and options
    Font Size (0 = Automatic)chromeFontSizeNumber
    Text Color (empty = theme)chromeColorColour
    Background (empty = theme)chromeBackgroundColour

    Roll-Ups & Span of Controlanalytics

    SettingType and options
    Roll-Ups on Cards (Premium)showRollupsOn / off
    Total Headcount Below Each ManagershowHeadcountOn / off
    Include the Manager in Roll-UpsincludeSelfOn / off
    Roll Up Values Asaggregate
    • Sum sum
    • Average avg
    • Minimum min
    • Maximum max
    Open Positions CountshowVacanciesOn / off
    Assistants Count Toward SpanassistantsInSpanOn / off
    Count Contractors in HeadcountcountContractorsOn / off
    Plan vs Actual (Premium)showVarianceOn / off
    Variance: Neutral Within +/- %varianceLowNumber
    Variance: Amber Within +/- % (Beyond = Red)varianceHighNumber
    Above Plan Is FavourablehigherIsGoodOn / off
    Headcount Trend on Manager Cards (Premium)showHistoryOn / off
    Health Panel Button (Premium)showHealthButtonOn / off
    Hide Figures for Groups Smaller Than (0 = Off)privacyKNumber
    Span of Control: Narrow up tospanLowNumber
    Span of Control: Ideal up tospanIdealNumber
    Span of Control: Wide up to (Above = Over)spanHighNumber
    Insights Strip (Premium)showInsightsOn / off

    Snapshot Comparisoncomparison

    SettingType and options
    Compare the Two Latest Snapshots (Premium)enabledOn / off
    Show Leavers as Ghost CardsshowLeaversOn / off
    Change Summary StripshowSummaryOn / off
    ShowcomparisonShow
    • All People all
    • Changed Branches Only changed

    Themetheme

    SettingType and options
    ThemeselectedTheme
    • SmartVisuals smartvisuals
    • Dark dark
    • Clean (White) clean
    • Slate slate
    Background Color (empty = theme)bgColorColour
    Transparent BackgroundtransparentBgOn / off

    Accessibilityaccessibility

    SettingType and options
    Focus Outline Color (empty = default)focusColorColour
    Focus Outline WidthfocusWidthNumber
    Minimum Text SizeminFontSizeNumber
    Reduce MotionreduceMotion
    • Follow System Setting system
    • Always always
    • Off (Always Animate) off

    Statestate

    SettingType and options
    CollapsedcollapsedText
    ExpandedexpandedText
    FocusfocusIdText
    Expand LevelsexpandLevelsNumber
    ViewviewText
    Color KeyscolorKeysText
    Compared SnapshotscomparePairText

    Scenariosscenarios

    SettingType and options
    ScenariosdataText
    Active ScenarioactiveNumber

    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": "orgChart198BA137CFFE4E33AFF8A22A8BC151CF",
      "objects": {
        "hierarchy": [{
          "properties": {
            "caseInsensitiveIds": { "expr": { "Literal": { "Value": "true" } } }
          }
        }]
      }
    }