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
| Field | Takes | Needed | What it is for |
|---|---|---|---|
Employee IDemployeeId | Column | Optional | Unique id per person. Any type: numbers, codes, emails. The chart is built by matching Manager ID to this. |
Position IDpositionId | Column | Optional | Optional. 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 IDmanagerId | Column | Optional | The Employee ID of the person's manager. Blank = top of the organisation. Unknown ids are grouped under Unassigned and explained, never an error. |
Namename | Column | Optional | Card headline. |
Job Titletitle | Column | Optional | Second line on the card. |
Departmentgroup | Column | Optional | Colours the cards and fills the legend; shown on detailed cards. |
Photo (Data URI)photo | Column | Optional · up to 5 | A 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. |
Emailemail | Column | Optional | Work e-mail. Adds Chat in Teams and Email to the card actions and is searchable. Links open only on a click. |
Profile URLprofileUrl | Column | Optional | An https link to the person's profile (HR system, intranet). Adds Open profile to the card actions. |
Extra Card Lineslines | Column | Optional · up to 3 | Up to two more text fields on detailed cards (location, email, cost centre). |
Color BycolorBy | Column | Optional | Overrides Department as the colour key. |
Sort KeysortKey | Column | Optional | Order of reports under the same manager. Numbers sort numerically. |
Dotted-Line Manager IDdottedManagerId | Column | Optional | A secondary reporting line, drawn dashed. Does not change roll-ups. |
Card TypecardType | Column | Optional | employee (default), vacancy, assistant or contractor. Vacancies draw as open-position cards and count separately. |
Snapshot Datesnapshot | Column | Optional | Bind when the table holds several snapshots of the organisation. The newest renders; with two, joiners, leavers and moves are highlighted (Premium). |
Valuesvalues | Measure | Optional · up to 4 | Numbers per person (FTE, cost, open requisitions). Shown on the card and rolled up through the tree (Premium). |
Plan Valuesplans | Measure | Optional · up to 4 | Targets paired with Values by position (1st plan with 1st value): plan vs actual variance on every card (Premium). |
Compositioncomposition | Column | Optional | A category (gender, contract type, grade, location) drawn as a 100% bar of each team (Premium). |
Badgesbadges | Column | Optional · up to 4 | Up to four flag columns (key person, flight risk, successor ready). yes / true / 1 / x shows the badge. |
Tooltipstooltips | Measure | Optional · up to 8 | Extra fields for the tooltip. |
Hierarchyhierarchy
| Setting | Type and options |
|---|---|
Employees Whose Manager Is Missingorphans |
|
Match IDs Ignoring CasecaseInsensitiveIds | On / off |
Order Reports BysiblingOrder |
|
Levels Open by DefaultautoExpandLevels | Number |
Stack Teams of at Least (0 = Never)stackLeavesFrom | Number |
Stacked Team ColumnsstackColumns | Number |
Manager ID HoldsmanagerRefersTo |
|
Assistants Beside Their ManagerassistantSlot | On / off |
Fold Teams of at Least (0 = Never)foldTeamsFrom | Number |
Group Siblings BygroupBy |
|
ShowviewMode |
|
Cardscards
| Setting | Type and options |
|---|---|
Card Sizedensity |
|
Photo or InitialsshowPhotos | On / off |
Job TitleshowTitle | On / off |
Department Line (Detailed Cards)showGroup | On / off |
Extra Card Lines (Detailed Cards)showLines | On / off |
Direct Reports CountshowDirectCount | On / off |
Expand / Collapse ButtonsshowExpandChips | On / off |
FontfontFamily |
|
Font SizefontSize | Number |
Chip LabelschipLabels |
|
Card StylecardStyle
| Setting | Type and options |
|---|---|
Card Fill (empty = theme)fillColor | Colour |
Border Color (empty = theme)borderColor | Colour |
Custom ShapecustomShape | On / off |
Corner RadiuscornerRadius | Number |
Border WidthborderWidth | Number |
Shadowshadow | On / off |
Name Color (empty = theme)nameColor | Colour |
Job Title Color (empty = theme)titleColor | Colour |
Detail Lines Color (empty = theme)detailColor | Colour |
Colors & Connectorscolors
| Setting | Type and options |
|---|---|
Color Cards BycolorMode |
|
Connector StyleconnectorStyle |
|
Connector LineconnectorDash |
|
Connector Color (empty = theme)connectorColor | Colour |
Connector WidthconnectorWidth | Number |
Dotted-Line ManagersshowDotted | On / off |
Dotted-Line Color (empty = theme)dottedColor | Colour |
Department ColorsdepartmentColors
| Setting | Type and options |
|---|---|
Department Color 1c0 | Colour |
Department Color 2c1 | Colour |
Department Color 3c2 | Colour |
Department Color 4c3 | Colour |
Department Color 5c4 | Colour |
Department Color 6c5 | Colour |
Department Color 7c6 | Colour |
Department Color 8c7 | Colour |
Department Color 9c8 | Colour |
Department Color 10c9 | Colour |
Department Color 11c10 | Colour |
Department Color 12c11 | Colour |
Department Color 13c12 | Colour |
Department Color 14c13 | Colour |
Department Color 15c14 | Colour |
Department Color 16c15 | Colour |
Department Color 17c16 | Colour |
Department Color 18c17 | Colour |
Department Color 19c18 | Colour |
Department Color 20c19 | Colour |
Department Color 21c20 | Colour |
Department Color 22c21 | Colour |
Department Color 23c22 | Colour |
Department Color 24c23 | Colour |
Department Color 25c24 | Colour |
Department Color 26c25 | Colour |
Department Color 27c26 | Colour |
Department Color 28c27 | Colour |
Department Color 29c28 | Colour |
Department Color 30c29 | Colour |
Team Compositioncomposition
| Setting | Type and options |
|---|---|
Composition Bar (Premium)showComposition | On / off |
Bar CoverscompositionScope |
|
Composition ColorscompositionColors
| Setting | Type and options |
|---|---|
Composition Color 1k0 | Colour |
Composition Color 2k1 | Colour |
Composition Color 3k2 | Colour |
Composition Color 4k3 | Colour |
Composition Color 5k4 | Colour |
Composition Color 6k5 | Colour |
Composition Color 7k6 | Colour |
Composition Color 8k7 | Colour |
Composition Color 9k8 | Colour |
Composition Color 10k9 | Colour |
Composition Color 11k10 | Colour |
Composition Color 12k11 | Colour |
BadgesbadgeStyle
| Setting | Type and options |
|---|---|
Badge 1 Iconb0Icon |
|
Badge 1 Colorb0Color | Colour |
Badge 2 Iconb1Icon |
|
Badge 2 Colorb1Color | Colour |
Badge 3 Iconb2Icon |
|
Badge 3 Colorb2Color | Colour |
Badge 4 Iconb3Icon |
|
Badge 4 Colorb3Color | Colour |
Any Text Counts as OnanyValue | On / off |
Rules (fx)conditional
| Setting | Type and options |
|---|---|
Card FillfxFill | Colour |
AccentfxAccent | Colour |
Name ColorfxName | Colour |
Job Title ColorfxTitle | Colour |
Chip FillfxChip | Colour |
Legendlegend
| Setting | Type and options |
|---|---|
Show LegendshowLegend | On / off |
PositionlegendPosition |
|
Font Size (0 = Card Font)legendFontSize | Number |
Text Color (empty = theme)legendColor | Colour |
Layoutlayout
| Setting | Type and options |
|---|---|
Directionorientation |
|
Space Between CardsgapX | Number |
Space Between LevelsgapY | Number |
Fit to Tile When Data ChangesfitOnLoad | On / off |
PDF Exportexport
| Setting | Type and options |
|---|---|
LayoutpdfMode |
|
Paper SizepaperSize |
|
OrientationpaperOrientation |
|
Title (empty = none)pdfTitle | Text |
Export Date LinepdfDate | On / off |
Toolbar & Stripschrome
| Setting | Type and options |
|---|---|
Font Size (0 = Automatic)chromeFontSize | Number |
Text Color (empty = theme)chromeColor | Colour |
Background (empty = theme)chromeBackground | Colour |
Roll-Ups & Span of Controlanalytics
| Setting | Type and options |
|---|---|
Roll-Ups on Cards (Premium)showRollups | On / off |
Total Headcount Below Each ManagershowHeadcount | On / off |
Include the Manager in Roll-UpsincludeSelf | On / off |
Roll Up Values Asaggregate |
|
Open Positions CountshowVacancies | On / off |
Assistants Count Toward SpanassistantsInSpan | On / off |
Count Contractors in HeadcountcountContractors | On / off |
Plan vs Actual (Premium)showVariance | On / off |
Variance: Neutral Within +/- %varianceLow | Number |
Variance: Amber Within +/- % (Beyond = Red)varianceHigh | Number |
Above Plan Is FavourablehigherIsGood | On / off |
Headcount Trend on Manager Cards (Premium)showHistory | On / off |
Health Panel Button (Premium)showHealthButton | On / off |
Hide Figures for Groups Smaller Than (0 = Off)privacyK | Number |
Span of Control: Narrow up tospanLow | Number |
Span of Control: Ideal up tospanIdeal | Number |
Span of Control: Wide up to (Above = Over)spanHigh | Number |
Insights Strip (Premium)showInsights | On / off |
Snapshot Comparisoncomparison
| Setting | Type and options |
|---|---|
Compare the Two Latest Snapshots (Premium)enabled | On / off |
Show Leavers as Ghost CardsshowLeavers | On / off |
Change Summary StripshowSummary | On / off |
ShowcomparisonShow |
|
Themetheme
| Setting | Type and options |
|---|---|
ThemeselectedTheme |
|
Background Color (empty = theme)bgColor | Colour |
Transparent BackgroundtransparentBg | On / off |
Accessibilityaccessibility
| Setting | Type and options |
|---|---|
Focus Outline Color (empty = default)focusColor | Colour |
Focus Outline WidthfocusWidth | Number |
Minimum Text SizeminFontSize | Number |
Reduce MotionreduceMotion |
|
Statestate
| Setting | Type and options |
|---|---|
Collapsedcollapsed | Text |
Expandedexpanded | Text |
FocusfocusId | Text |
Expand LevelsexpandLevels | Number |
Viewview | Text |
Color KeyscolorKeys | Text |
Compared SnapshotscomparePair | Text |
Scenariosscenarios
| Setting | Type and options |
|---|---|
Scenariosdata | Text |
Active Scenarioactive | Number |
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" } } }
}
}]
}
}