Part-to-Whole 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 Part-to-Whole page; every setting works in edit mode with or without one.
25 fields · 38 cards · 245 settings Markdown for AI assistantscatalog.json
Fields
| Field | Takes | Needed | What it is for |
|---|---|---|---|
Categorycategory | Column | Optional | The parts: slices, petals, rings, cells, icons, stages or columns |
Segmentsegment | Column | Optional | A second split: an outer ring, stacked petals or stages, Marimekko rows, waffle colours |
Valuesvalues | Measure | Optional | The size of each part |
Comparecompare | Measure | Optional | Last period, plan or any reference: share shift, ghost marks, findings (premium) |
Targettarget | Measure | Optional | A goal per part |
Widthwidth | Measure | Optional | Column width (else each column's total) |
Angle (aster)angle | Measure | Optional | Petal angle in the aster layout |
Stage orderstageOrder | Measure | Optional | Sort key of the stages (1, 2, 3...) |
Win probabilityprobability | Measure | Optional | Chance each stage closes (0-1 or %): weighted pipeline (premium) |
Unitsunits | Measure | Optional | Quantities behind Values: splits the change into volume, mix and price (premium) |
Compare unitscompareUnits | Measure | Optional | Quantities behind Compare (premium) |
Sample sizesampleSize | Measure | Optional | Respondents behind each share: margin of error (premium) |
Effective baseeffectiveBase | Measure | Optional | Kish effective base of weighted data, (Σw)² / Σw² (premium) |
Period elapsedelapsed | Measure | Optional | Share of the period gone (0-1 or %): pace and landing (premium) |
Plan to dateplanToDate | Measure | Optional | Where the actual should be today, if not linear (premium) |
Iconicon | Measure | Optional | Built-in icon name, SVG path or data:image URI per part |
Annotationannotation | Measure | Optional | Text measure: a callout on the part |
Play axisplay | Column | Optional | Periods to play through (premium) |
Seasonsseason | Column | Optional | Periods such as years: the latest is drawn, the past ones as outlines behind it (premium) |
Small multiplesfacet | Column | Optional | One chart per value |
Tooltipstooltips | Measure | Optional | Extra fields in tooltips |
Centre valuecentreValue | Measure | Optional | Shown in the centre instead of the total (a ratio: make every part return the same value, e.g. with ALLSELECTED) |
Loss reasonlossReason | Column | Optional | Why the lost left each step (blank = still open or won): splits the leak ribbons by reason (premium) |
Show conditionshowCondition | Measure | Optional | A measure returning 1 / TRUE to show the chart, 0 / FALSE / blank to show a message instead |
Compare basecompareBase | Measure | Optional | Effective base (or sample size) of the Compare wave: the wave test uses it instead of the current base (premium) |
Viewview
| Setting | Type and options |
|---|---|
Charttype |
|
Show View TabsshowTabs | On / off |
Mosaic (2-4 Views Side by Side)mosaic | On / off |
Mosaic View 1mosaic1 |
|
Mosaic View 2mosaic2 |
|
Mosaic View 3mosaic3 |
|
Mosaic View 4mosaic4 |
|
Templatestemplates
| Setting | Type and options |
|---|---|
Style Templatepreset |
|
Appliedapplied | Text |
Pie & Donutpie
| Setting | Type and options |
|---|---|
Shapeshape |
|
Hole Size (%)innerRadius | Number |
Arcarc |
|
Start Angle (°)startAngle | Number |
Sweep (°)sweep | Number |
Gaps Between Slicesgap |
|
Cornerscorners |
|
Pull Out the Selected Sliceexplode | On / off |
Segment Field Asnested |
|
Segment Names on the RingsegmentLabels | On / off |
Bar of Pie (Expand Other)barOfPie | On / off |
Spotlightspotlight |
|
Spotlight SlicespotlightName | Text |
Images in Slicesimages | On / off |
Depth Style (no tilt)depth | On / off |
Roserose
| Setting | Type and options |
|---|---|
Petal Sizemode |
|
Arcarc |
|
Start Angle (°)startAngle | Number |
Sweep (°)sweep | Number |
Inner Radius (%)innerRadius | Number |
Stack Petals by Segmentstacked | On / off |
Orderorder |
|
Calendar Order for Months and Dayscalendar | On / off |
Past Seasons as Outlinesseasons | Number |
Images in Petalsimages | On / off |
Gaps Between Petalsgap |
|
Radial AxisradialAxis
| Setting | Type and options |
|---|---|
Grid Circlesshow | On / off |
Axis Valueslabels | On / off |
Number of Circlescount | Number |
Maximum (0 = auto)max | Number |
Grid Colourcolor | Colour |
Radial Barradial
| Setting | Type and options |
|---|---|
Layoutmode |
|
Arcarc |
|
Start Angle (°)startAngle | Number |
Inner Radius (%)innerRadius | Number |
Gap Between Rings (%)gap | Number |
Tracktrack | On / off |
Bar Endscaps |
|
Ring LabelslabelPosition |
|
Depth Style (no tilt)depth | On / off |
Status Bands on the Trackbands | On / off |
Wafflewaffle
| Setting | Type and options |
|---|---|
Gridgrid |
|
Rowsrows | Number |
Columnscolumns | Number |
Units per Cell (0 = auto)unitValue | Number |
Layoutlayout |
|
Fill Directionfill |
|
Cell ShapecellShape |
|
Iconicon |
|
Custom Icon (SVG path or data:image)customIcon | Text |
Cell Gap (%)gap | Number |
Headline Numberheadline | On / off |
Headline ShowsheadlineFocus |
|
Empty Cell ColouremptyColor | Colour |
Show “1 cell = N” Under the GridunitNote | On / off |
Show “% of Target” in the LabelstargetText | On / off |
Fill-In AnimationfillIn | On / off |
Hover Spotlightspotlight | On / off |
Pictogrampictogram
| Setting | Type and options |
|---|---|
Layoutmode |
|
Iconicon |
|
Custom Icon (SVG path or data:image)customIcon | Text |
Units per Icon (0 = auto)unitValue | Number |
Icons per Row (0 = auto)perRow | Number |
Parliament Shapespan |
|
Majoritymajority |
|
Seats Neededquota | Number |
Card ReadscardStyle |
|
Empty Icon ColouremptyColor | Colour |
Seat Total in the Centrereadout | On / off |
Card CaptioncardCaption | On / off |
Fill-In AnimationfillIn | On / off |
Hover Spotlightspotlight | On / off |
Funnel & Pyramidfunnel
| Setting | Type and options |
|---|---|
Chartstyle |
|
Orientationorientation |
|
Shapeshape |
|
Level Heightsheights |
|
Connector Areasconnectors | On / off |
Minimum Stage Width (%)minWidth | Number |
Segment Field Assegments |
|
Conversion Pillspills | On / off |
Leak Ribbons (What Each Step Loses)leaks | On / off |
Leak Ribbon LabelsleakLabels | On / off |
Lane TitleslaneTitles | On / off |
% of First StageshowPctFirst | On / off |
% of Previous StageshowPctPrevious | On / off |
Drop %showDrop | On / off |
Lost (Absolute)showLoss | On / off |
Data Checks (edit mode)diagnostics | On / off |
Marimekkomarimekko
| Setting | Type and options |
|---|---|
Chartmode |
|
Orientationorientation |
|
Sort ColumnssortColumns |
|
Sort SegmentssortSegments |
|
Top N Segments per Column (0 = automatic)topSegments | Number |
Fold Small Players into OtherautoOther | On / off |
Labels Outside Thin CellsoutsideLabels | On / off |
Column LabelscolumnLabels | On / off |
Column TotalscolumnTotals | On / off |
Cell PercentagescellPercent |
|
Hide Labels in Cells Below (% of area)minLabelShare | Number |
Value AxispercentAxis | On / off |
Column Axis TitlexTitle | Text |
Value Axis TitleyTitle | Text |
Relative Market SharerelativeShare | On / off |
Focus PlayerfocusPlayer | Text |
Where Is the Prizeprize | On / off |
Prize LabelsprizeLabels | On / off |
Prize: Up to a Share of (%, 0 = whole market)prizeShare | Number |
Cost Curve: Demand (0 = off)threshold | Number |
Demand Line LabeldemandLabel | On / off |
% of Target Above ColumnstargetBand | On / off |
Sorting and Othersorting
| Setting | Type and options |
|---|---|
Sortsort |
|
Readers Can Change the SortreaderSort | On / off |
Group Small Items Into Otherother | On / off |
Show at Most (items)maxItems | Number |
Group Items Below (%)minShare | Number |
Other LabelotherLabel | Text |
Data Labelslabels
| Setting | Type and options |
|---|---|
Showshow | On / off |
Contentcontent |
|
Positionposition |
|
Percent DecimalspercentDecimals | Number |
Display UnitsdisplayUnits |
|
Value Decimals (-1 = auto)valueDecimals | Number |
Hide Labels Below (%)hideBelow | Number |
Font SizefontSize | Number |
Text Colourcolor | Colour |
Detail Text SizedetailSize | Number |
Detail Text ColourdetailColor | Colour |
Centrecentre
| Setting | Type and options |
|---|---|
Showshow | On / off |
Contentcontent |
|
Caption Under the Valuelabel | Text |
Value Font Size (0 = auto)fontSize | Number |
Text Colourcolor | Colour |
Legendlegend
| Setting | Type and options |
|---|---|
Showshow | On / off |
Positionposition |
|
Font SizefontSize | Number |
Text Colourcolor | Colour |
Colour RulescolorRules
| Setting | Type and options |
|---|---|
Rulemode |
|
Top NtopN | Number |
Thresholdthreshold | Number |
Highlight / Above ColourhighColor | Colour |
Others / Below ColourlowColor | Colour |
Comparecompare
| Setting | Type and options |
|---|---|
Show the Comparisonshow | On / off |
Comparison Namename | Text |
Change Labelslabels |
|
Draw the Comparison (ghost)ghost | On / off |
Sort by ChangesortByChange | On / off |
Volume vs Mix SplitvolumeMix | On / off |
Concentration (HHI, top 3)concentration | On / off |
Share Bridge (points won and lost)shareBridge | On / off |
Movers in the BridgebridgeItems | Number |
Segment CAGR Above Columnscagr | On / off |
Years Between the Periodsyears | Number |
Targetstargets
| Setting | Type and options |
|---|---|
Show Targetsshow | On / off |
One Target for All (0 = off)global | Number |
Met at (% of target)metAt | Number |
Close at (% of target)closeAt | Number |
Met ColourmetColor | Colour |
Close ColourcloseColor | Colour |
Missed ColourmissedColor | Colour |
Colour Items by StatusstatusColors | On / off |
Pacepace
| Setting | Type and options |
|---|---|
Show Paceshow | On / off |
Share of Period Elapsed (%, 0 = from the field or dates)elapsed | Number |
Period Start (yyyy-mm-dd)periodStart | Text |
Period End (yyyy-mm-dd)periodEnd | Text |
On Track Within (%)tolerance | Number |
Projected Landingprojection | On / off |
Required Run RaterunRate | On / off |
Run Rate perunit |
|
Units in the Whole Period (0 = a year, or from the dates)units | Number |
Significancesignificance
| Setting | Type and options |
|---|---|
Test the Changeshow | On / off |
Significance Levelalpha |
|
Values ArevaluesAre |
|
Test Againstreference |
|
Survey Marginssurvey
| Setting | Type and options |
|---|---|
Show the Margin of Errorshow | On / off |
Confidenceconfidence |
|
Intervalmethod |
|
Margin Text in the LabelsmarginText | On / off |
Test the Change vs the Compare WavewaveTest | On / off |
Plan the Next Wave: Margin Wanted (± pp, 0 = off)planMargin | Number |
Plan ForplanShare |
|
Coalition Buildercoalition
| Setting | Type and options |
|---|---|
Show Coalitionsshow | On / off |
Parties in the Coalitionparties | Text |
List Minimal Winning Coalitionslist | On / off |
Seat Sum Readoutreadout | On / off |
Pipeline & Forecastpipeline
| Setting | Type and options |
|---|---|
Show Expected Valueshow | On / off |
Stages ArestagesAre |
|
Last Stage Is Won (counted at 100 %)lastIsWon | On / off |
Pipeline Coveragecoverage |
|
Quota (0 = the last stage's Target)quota | Number |
Forecast Line Under the CharttotalLine | On / off |
What IfwhatIf
| Setting | Type and options |
|---|---|
Lift One Stepshow | On / off |
Step Into Stage (blank = the weakest step)step | Text |
Uplift (percentage points)uplift | Number |
Uplift LabelsshowText | On / off |
Play Over Periodsplay
| Setting | Type and options |
|---|---|
Seconds per Periodspeed | Number |
Looploop | On / off |
Findingsfindings
| Setting | Type and options |
|---|---|
What Changed (findings)show | On / off |
Number of Findingsmax | Number |
Font SizefontSize | Number |
Text Colourcolor | Colour |
Smart Captioncaption
| Setting | Type and options |
|---|---|
Showshow | On / off |
Positionposition |
|
Font SizefontSize | Number |
Text Colourcolor | Colour |
Small MultiplessmallMultiples
| Setting | Type and options |
|---|---|
Columns (0 = auto)columns | Number |
Shared ScalesharedScale | On / off |
Size Pies by Their TotalsizeByTotal | On / off |
Title Font SizetitleSize | Number |
Title ColourtitleColor | Colour |
Annotationsannotations
| Setting | Type and options |
|---|---|
Showshow | On / off |
Font SizefontSize | Number |
Colourcolor | Colour |
Show ConditionshowCondition
| Setting | Type and options |
|---|---|
Message When Hiddenmessage | Text |
Data TabledataTable
| Setting | Type and options |
|---|---|
Table Button in the Visualbutton | On / off |
Open as Tablestart | On / off |
Zoomzoom
| Setting | Type and options |
|---|---|
Ctrl + Wheel Zooms, Drag Pansenabled | On / off |
Footnotefootnote
| Setting | Type and options |
|---|---|
Showshow | On / off |
Sourcesource | Text |
State the MethodsshowMethod | On / off |
Font SizefontSize | Number |
Text Colourcolor | Colour |
Axis Textaxes
| Setting | Type and options |
|---|---|
Show Axis Values and Titlesshow | On / off |
Font SizefontSize | Number |
Text Colourcolor | Colour |
Tabs and Buttonscontrols
| Setting | Type and options |
|---|---|
Font SizefontSize | Number |
Text Colourcolor | Colour |
Accessibilityaccessibility
| Setting | Type and options |
|---|---|
Patterns (Tell Items Apart Without Colour)patterns | On / off |
Focus Outline ColourfocusColor | Colour |
Focus Outline WidthfocusWidth | Number |
Minimum Text Size (0 = off)minFontSize | Number |
Reduce MotionreduceMotion | On / off |
Themetheme
| Setting | Type and options |
|---|---|
ThemeselectedTheme |
|
Fontfont |
|
Transparent BackgroundtransparentBg | On / off |
Data ColoursdataPoint
| Setting | Type and options |
|---|---|
Colourfill | Colour |
Category IconscategoryIcon
| Setting | Type and options |
|---|---|
Iconicon | Text |
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": "smartvisualsPartToWhole553C74E0A67D23C286D3CA02B73AF59F",
"objects": {
"view": [{
"properties": {
"showTabs": { "expr": { "Literal": { "Value": "true" } } }
}
}]
}
}