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

    FieldTakesNeededWhat it is for
    CategorycategoryColumnOptionalThe parts: slices, petals, rings, cells, icons, stages or columns
    SegmentsegmentColumnOptionalA second split: an outer ring, stacked petals or stages, Marimekko rows, waffle colours
    ValuesvaluesMeasureOptionalThe size of each part
    ComparecompareMeasureOptionalLast period, plan or any reference: share shift, ghost marks, findings (premium)
    TargettargetMeasureOptionalA goal per part
    WidthwidthMeasureOptionalColumn width (else each column's total)
    Angle (aster)angleMeasureOptionalPetal angle in the aster layout
    Stage orderstageOrderMeasureOptionalSort key of the stages (1, 2, 3...)
    Win probabilityprobabilityMeasureOptionalChance each stage closes (0-1 or %): weighted pipeline (premium)
    UnitsunitsMeasureOptionalQuantities behind Values: splits the change into volume, mix and price (premium)
    Compare unitscompareUnitsMeasureOptionalQuantities behind Compare (premium)
    Sample sizesampleSizeMeasureOptionalRespondents behind each share: margin of error (premium)
    Effective baseeffectiveBaseMeasureOptionalKish effective base of weighted data, (Σw)² / Σw² (premium)
    Period elapsedelapsedMeasureOptionalShare of the period gone (0-1 or %): pace and landing (premium)
    Plan to dateplanToDateMeasureOptionalWhere the actual should be today, if not linear (premium)
    IconiconMeasureOptionalBuilt-in icon name, SVG path or data:image URI per part
    AnnotationannotationMeasureOptionalText measure: a callout on the part
    Play axisplayColumnOptionalPeriods to play through (premium)
    SeasonsseasonColumnOptionalPeriods such as years: the latest is drawn, the past ones as outlines behind it (premium)
    Small multiplesfacetColumnOptionalOne chart per value
    TooltipstooltipsMeasureOptionalExtra fields in tooltips
    Centre valuecentreValueMeasureOptionalShown in the centre instead of the total (a ratio: make every part return the same value, e.g. with ALLSELECTED)
    Loss reasonlossReasonColumnOptionalWhy the lost left each step (blank = still open or won): splits the leak ribbons by reason (premium)
    Show conditionshowConditionMeasureOptionalA measure returning 1 / TRUE to show the chart, 0 / FALSE / blank to show a message instead
    Compare basecompareBaseMeasureOptionalEffective base (or sample size) of the Compare wave: the wave test uses it instead of the current base (premium)

    Viewview

    SettingType and options
    Charttype
    • Pie & Donut pie
    • Rose rose
    • Radial Bar radial
    • Waffle waffle
    • Pictogram pictogram
    • Funnel & Pyramid funnel
    • Marimekko marimekko
    Show View TabsshowTabsOn / off
    Mosaic (2-4 Views Side by Side)mosaicOn / off
    Mosaic View 1mosaic1
    • Pie & Donut pie
    • Rose rose
    • Radial Bar radial
    • Waffle waffle
    • Pictogram pictogram
    • Funnel & Pyramid funnel
    • Marimekko marimekko
    Mosaic View 2mosaic2
    • Pie & Donut pie
    • Rose rose
    • Radial Bar radial
    • Waffle waffle
    • Pictogram pictogram
    • Funnel & Pyramid funnel
    • Marimekko marimekko
    Mosaic View 3mosaic3
    • Pie & Donut pie
    • Rose rose
    • Radial Bar radial
    • Waffle waffle
    • Pictogram pictogram
    • Funnel & Pyramid funnel
    • Marimekko marimekko
    • (none) none
    Mosaic View 4mosaic4
    • Pie & Donut pie
    • Rose rose
    • Radial Bar radial
    • Waffle waffle
    • Pictogram pictogram
    • Funnel & Pyramid funnel
    • Marimekko marimekko
    • (none) none

    Templatestemplates

    SettingType and options
    Style Templatepreset
    • None (style defaults) none
    • Executive executive
    • IBCS (Finance) ibcs
    • Minimal minimal
    • Presentation presentation
    • Print print
    • Infographic infographic
    • Custom custom
    AppliedappliedText

    Pie & Donutpie

    SettingType and options
    Shapeshape
    • Donut donut
    • Pie pie
    Hole Size (%)innerRadiusNumber
    Arcarc
    • Full circle full
    • Semicircle semi
    • Three quarters (270°) threeQuarter
    • Custom start and sweep custom
    Start Angle (°)startAngleNumber
    Sweep (°)sweepNumber
    Gaps Between Slicesgap
    • From theme theme
    • None none
    • Small small
    • Large large
    Cornerscorners
    • From theme theme
    • Square square
    • Rounded rounded
    Pull Out the Selected SliceexplodeOn / off
    Segment Field Asnested
    • Outer ring (nested donut) ring
    • Shades inside each slice shades
    • Ignore ignore
    Segment Names on the RingsegmentLabelsOn / off
    Bar of Pie (Expand Other)barOfPieOn / off
    Spotlightspotlight
    • None none
    • The largest slice largest
    • A slice by name named
    Spotlight SlicespotlightNameText
    Images in SlicesimagesOn / off
    Depth Style (no tilt)depthOn / off

    Roserose

    SettingType and options
    Petal Sizemode
    • By area (honest) area
    • By radius radius
    • Aster: angle from a second measure aster
    Arcarc
    • Full circle full
    • Semicircle semi
    • Three quarters (270°) threeQuarter
    • Custom start and sweep custom
    Start Angle (°)startAngleNumber
    Sweep (°)sweepNumber
    Inner Radius (%)innerRadiusNumber
    Stack Petals by SegmentstackedOn / off
    Orderorder
    • Auto (months, weekdays, hours, compass) auto
    • Calendar (months, quarters) calendar
    • Weekdays (Monday first) weekday
    • Hours of the day (midnight at the top) hour
    • Compass points (north at the top) compass
    • As the Sorting card sort
    Calendar Order for Months and DayscalendarOn / off
    Past Seasons as OutlinesseasonsNumber
    Images in PetalsimagesOn / off
    Gaps Between Petalsgap
    • From theme theme
    • None none
    • Small small
    • Large large

    Radial AxisradialAxis

    SettingType and options
    Grid CirclesshowOn / off
    Axis ValueslabelsOn / off
    Number of CirclescountNumber
    Maximum (0 = auto)maxNumber
    Grid ColourcolorColour

    Radial Barradial

    SettingType and options
    Layoutmode
    • Auto (rings when a target is set) auto
    • Radial bars (shared maximum) bars
    • Progress rings (each to its target) rings
    • Single ring (KPI) single
    Arcarc
    • Three quarters (270°) threeQuarter
    • Full circle full
    • Semicircle semi
    Start Angle (°)startAngleNumber
    Inner Radius (%)innerRadiusNumber
    Gap Between Rings (%)gapNumber
    TracktrackOn / off
    Bar Endscaps
    • From theme theme
    • Rounded round
    • Square square
    Ring LabelslabelPosition
    • At the start of each ring start
    • At the end of each bar end
    • None none
    Depth Style (no tilt)depthOn / off
    Status Bands on the TrackbandsOn / off

    Wafflewaffle

    SettingType and options
    Gridgrid
    • Percent grid (each cell = 1 %) percent
    • Unit grid (each cell = N units) unit
    RowsrowsNumber
    ColumnscolumnsNumber
    Units per Cell (0 = auto)unitValueNumber
    Layoutlayout
    • One grid, all categories stacked
    • One grid per category perCategory
    Fill Directionfill
    • Row by row row
    • Column by column column
    • Snake snake
    Cell ShapecellShape
    • From theme theme
    • Square square
    • Rounded square rounded
    • Circle (dot matrix) circle
    • Icon icon
    Iconicon
    • Person person
    • People people
    • Woman woman
    • Man man
    • Building building
    • Factory factory
    • House house
    • Box box
    • Truck truck
    • Car car
    • Shopping cart cart
    • Dollar dollar
    • Euro euro
    • Coin coin
    • Heart heart
    • Star star
    • Leaf leaf
    • Water Drop drop
    • Bolt bolt
    • Laptop laptop
    • Phone phone
    • Seat seat
    • Check mark check
    • Circle circle
    • Square square
    Custom Icon (SVG path or data:image)customIconText
    Cell Gap (%)gapNumber
    Headline NumberheadlineOn / off
    Headline ShowsheadlineFocus
    • The largest category largest
    • The first category first
    Empty Cell ColouremptyColorColour
    Show “1 cell = N” Under the GridunitNoteOn / off
    Show “% of Target” in the LabelstargetTextOn / off
    Fill-In AnimationfillInOn / off
    Hover SpotlightspotlightOn / off

    Pictogrampictogram

    SettingType and options
    Layoutmode
    • Isotype rows (one row per category) isotype
    • Icon array (one block) array
    • Parliament (hemicycle) parliament
    • Infographic card (one icon filled to %) card
    Iconicon
    • Person person
    • People people
    • Woman woman
    • Man man
    • Building building
    • Factory factory
    • House house
    • Box box
    • Truck truck
    • Car car
    • Shopping cart cart
    • Dollar dollar
    • Euro euro
    • Coin coin
    • Heart heart
    • Star star
    • Leaf leaf
    • Water Drop drop
    • Bolt bolt
    • Laptop laptop
    • Phone phone
    • Seat seat
    • Check mark check
    • Circle circle
    • Square square
    Custom Icon (SVG path or data:image)customIconText
    Units per Icon (0 = auto)unitValueNumber
    Icons per Row (0 = auto)perRowNumber
    Parliament Shapespan
    • Semicircle semicircle
    • Arch (240°) arch
    • Full circle full
    Majoritymajority
    • Simple majority (> 50 %) simple
    • Two thirds twoThirds
    • Three fifths threeFifths
    • Typed quota quota
    • None none
    Seats NeededquotaNumber
    Card ReadscardStyle
    • Share (e.g. 34 %) share
    • One in N oneIn
    • Progress to target progress
    Empty Icon ColouremptyColorColour
    Seat Total in the CentrereadoutOn / off
    Card CaptioncardCaptionOn / off
    Fill-In AnimationfillInOn / off
    Hover SpotlightspotlightOn / off

    Funnel & Pyramidfunnel

    SettingType and options
    Chartstyle
    • Funnel funnel
    • Pyramid pyramid
    • Inverted pyramid inverted
    Orientationorientation
    • Vertical vertical
    • Horizontal horizontal
    Shapeshape
    • Tapered tapered
    • Straight bars bars
    • Curved curved
    Level Heightsheights
    • Equal equal
    • Proportional to value proportional
    Connector AreasconnectorsOn / off
    Minimum Stage Width (%)minWidthNumber
    Segment Field Assegments
    • Stacked inside each stage stacked
    • Side by side (one funnel per segment) sideBySide
    Conversion PillspillsOn / off
    Leak Ribbons (What Each Step Loses)leaksOn / off
    Leak Ribbon LabelsleakLabelsOn / off
    Lane TitleslaneTitlesOn / off
    % of First StageshowPctFirstOn / off
    % of Previous StageshowPctPreviousOn / off
    Drop %showDropOn / off
    Lost (Absolute)showLossOn / off
    Data Checks (edit mode)diagnosticsOn / off

    Marimekkomarimekko

    SettingType and options
    Chartmode
    • 100 % Marimekko percent
    • Actual values (bar Mekko) actual
    • Cost curve (variable-width bars by height) costCurve
    Orientationorientation
    • Vertical columns vertical
    • Horizontal bars horizontal
    Sort ColumnssortColumns
    • Largest first desc
    • Smallest first asc
    • Name name
    • Data order data
    Sort SegmentssortSegments
    • Largest first (per column) desc
    • Same order in every column global
    • Name name
    • Data order data
    Top N Segments per Column (0 = automatic)topSegmentsNumber
    Fold Small Players into OtherautoOtherOn / off
    Labels Outside Thin CellsoutsideLabelsOn / off
    Column LabelscolumnLabelsOn / off
    Column TotalscolumnTotalsOn / off
    Cell PercentagescellPercent
    • % of column column
    • % of total total
    Hide Labels in Cells Below (% of area)minLabelShareNumber
    Value AxispercentAxisOn / off
    Column Axis TitlexTitleText
    Value Axis TitleyTitleText
    Relative Market SharerelativeShareOn / off
    Focus PlayerfocusPlayerText
    Where Is the PrizeprizeOn / off
    Prize LabelsprizeLabelsOn / off
    Prize: Up to a Share of (%, 0 = whole market)prizeShareNumber
    Cost Curve: Demand (0 = off)thresholdNumber
    Demand Line LabeldemandLabelOn / off
    % of Target Above ColumnstargetBandOn / off

    Sorting and Othersorting

    SettingType and options
    Sortsort
    • Largest first desc
    • Smallest first asc
    • Name name
    • Data order data
    • Stage order field order
    Readers Can Change the SortreaderSortOn / off
    Group Small Items Into OtherotherOn / off
    Show at Most (items)maxItemsNumber
    Group Items Below (%)minShareNumber
    Other LabelotherLabelText

    Data Labelslabels

    SettingType and options
    ShowshowOn / off
    Contentcontent
    • Category category
    • Value value
    • Percent of total percent
    • Category, percent categoryPercent
    • Category, value categoryValue
    • Value, percent valuePercent
    • Category, value, percent all
    Positionposition
    • Auto auto
    • Inside inside
    • Outside with leader lines outside
    Percent DecimalspercentDecimalsNumber
    Display UnitsdisplayUnits
    • Auto auto
    • None none
    • Thousands K
    • Millions M
    • Billions B
    Value Decimals (-1 = auto)valueDecimalsNumber
    Hide Labels Below (%)hideBelowNumber
    Font SizefontSizeNumber
    Text ColourcolorColour
    Detail Text SizedetailSizeNumber
    Detail Text ColourdetailColorColour

    Centrecentre

    SettingType and options
    ShowshowOn / off
    Contentcontent
    • Total total
    • Hovered item, else total hover
    • Largest item's share largest
    Caption Under the ValuelabelText
    Value Font Size (0 = auto)fontSizeNumber
    Text ColourcolorColour

    Legendlegend

    SettingType and options
    ShowshowOn / off
    Positionposition
    • Auto (only when labels do not name the items) auto
    • Top top
    • Bottom bottom
    • Right right
    • Left left
    Font SizefontSizeNumber
    Text ColourcolorColour

    Colour RulescolorRules

    SettingType and options
    Rulemode
    • None (one colour per item) none
    • Highlight the top N rank
    • Above / below a value value
    • Above / below a share (%) share
    Top NtopNNumber
    ThresholdthresholdNumber
    Highlight / Above ColourhighColorColour
    Others / Below ColourlowColorColour

    Comparecompare

    SettingType and options
    Show the ComparisonshowOn / off
    Comparison NamenameText
    Change Labelslabels
    • Share shift (pp) pp
    • Value change value
    • % change percent
    • None none
    Draw the Comparison (ghost)ghostOn / off
    Sort by ChangesortByChangeOn / off
    Volume vs Mix SplitvolumeMixOn / off
    Concentration (HHI, top 3)concentrationOn / off
    Share Bridge (points won and lost)shareBridgeOn / off
    Movers in the BridgebridgeItemsNumber
    Segment CAGR Above ColumnscagrOn / off
    Years Between the PeriodsyearsNumber

    Targetstargets

    SettingType and options
    Show TargetsshowOn / off
    One Target for All (0 = off)globalNumber
    Met at (% of target)metAtNumber
    Close at (% of target)closeAtNumber
    Met ColourmetColorColour
    Close ColourcloseColorColour
    Missed ColourmissedColorColour
    Colour Items by StatusstatusColorsOn / off

    Pacepace

    SettingType and options
    Show PaceshowOn / off
    Share of Period Elapsed (%, 0 = from the field or dates)elapsedNumber
    Period Start (yyyy-mm-dd)periodStartText
    Period End (yyyy-mm-dd)periodEndText
    On Track Within (%)toleranceNumber
    Projected LandingprojectionOn / off
    Required Run RaterunRateOn / off
    Run Rate perunit
    • Month month
    • Week week
    • Quarter quarter
    • Day day
    Units in the Whole Period (0 = a year, or from the dates)unitsNumber

    Significancesignificance

    SettingType and options
    Test the ChangeshowOn / off
    Significance Levelalpha
    • 95 % (α = 0.05) 0.05
    • 99 % (α = 0.01) 0.01
    • 90 % (α = 0.10) 0.1
    Values ArevaluesAre
    • Automatic (whole numbers, not currency or %) auto
    • Counts (opportunities, people, orders) counts
    • Amounts (revenue, value): not tested amounts
    Test Againstreference
    • The Compare field compare
    • The first segment firstSegment

    Survey Marginssurvey

    SettingType and options
    Show the Margin of ErrorshowOn / off
    Confidenceconfidence
    • 95 % 0.95
    • 90 % 0.9
    • 99 % 0.99
    Intervalmethod
    • Wilson wilson
    • Normal (Wald) normal
    Margin Text in the LabelsmarginTextOn / off
    Test the Change vs the Compare WavewaveTestOn / off
    Plan the Next Wave: Margin Wanted (± pp, 0 = off)planMarginNumber
    Plan ForplanShare
    • Every share (worst case p = 0.5) worst
    • Each observed share observed

    Coalition Buildercoalition

    SettingType and options
    Show CoalitionsshowOn / off
    Parties in the CoalitionpartiesText
    List Minimal Winning CoalitionslistOn / off
    Seat Sum ReadoutreadoutOn / off

    Pipeline & Forecastpipeline

    SettingType and options
    Show Expected ValueshowOn / off
    Stages ArestagesAre
    • Cumulative (each stage counts everyone who reached it) cumulative
    • In stage (each stage counts only those there now) inStage
    Last Stage Is Won (counted at 100 %)lastIsWonOn / off
    Pipeline Coveragecoverage
    • Off off
    • Forecast (expected + won) ÷ quota forecast
    • Open pipeline ÷ quota open
    Quota (0 = the last stage's Target)quotaNumber
    Forecast Line Under the CharttotalLineOn / off

    What IfwhatIf

    SettingType and options
    Lift One StepshowOn / off
    Step Into Stage (blank = the weakest step)stepText
    Uplift (percentage points)upliftNumber
    Uplift LabelsshowTextOn / off

    Play Over Periodsplay

    SettingType and options
    Seconds per PeriodspeedNumber
    LooploopOn / off

    Findingsfindings

    SettingType and options
    What Changed (findings)showOn / off
    Number of FindingsmaxNumber
    Font SizefontSizeNumber
    Text ColourcolorColour

    Smart Captioncaption

    SettingType and options
    ShowshowOn / off
    Positionposition
    • Top top
    • Bottom bottom
    Font SizefontSizeNumber
    Text ColourcolorColour

    Small MultiplessmallMultiples

    SettingType and options
    Columns (0 = auto)columnsNumber
    Shared ScalesharedScaleOn / off
    Size Pies by Their TotalsizeByTotalOn / off
    Title Font SizetitleSizeNumber
    Title ColourtitleColorColour

    Annotationsannotations

    SettingType and options
    ShowshowOn / off
    Font SizefontSizeNumber
    ColourcolorColour

    Show ConditionshowCondition

    SettingType and options
    Message When HiddenmessageText

    Data TabledataTable

    SettingType and options
    Table Button in the VisualbuttonOn / off
    Open as TablestartOn / off

    Zoomzoom

    SettingType and options
    Ctrl + Wheel Zooms, Drag PansenabledOn / off

    Footnotefootnote

    SettingType and options
    ShowshowOn / off
    SourcesourceText
    State the MethodsshowMethodOn / off
    Font SizefontSizeNumber
    Text ColourcolorColour

    Axis Textaxes

    SettingType and options
    Show Axis Values and TitlesshowOn / off
    Font SizefontSizeNumber
    Text ColourcolorColour

    Tabs and Buttonscontrols

    SettingType and options
    Font SizefontSizeNumber
    Text ColourcolorColour

    Accessibilityaccessibility

    SettingType and options
    Patterns (Tell Items Apart Without Colour)patternsOn / off
    Focus Outline ColourfocusColorColour
    Focus Outline WidthfocusWidthNumber
    Minimum Text Size (0 = off)minFontSizeNumber
    Reduce MotionreduceMotionOn / off

    Themetheme

    SettingType and options
    ThemeselectedTheme
    • SmartVisuals smartvisuals
    • Dark dark
    • Clean (White) clean
    • Slate slate
    Fontfont
    • Inter inter
    • Segoe UI segoe
    • Arial arial
    • Georgia georgia
    Transparent BackgroundtransparentBgOn / off

    Data ColoursdataPoint

    SettingType and options
    ColourfillColour

    Category IconscategoryIcon

    SettingType and options
    IconiconText

    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" } } }
          }
        }]
      }
    }