Bullet 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 Bullet Chart page; every setting works in edit mode with or without one.

    15 fields · 14 cards · 74 settings Markdown for AI assistantscatalog.json

    Fields

    FieldTakesNeededWhat it is for
    CategorycategoryColumnOptionalOne bullet per category: region, product, KPI name, plant line.
    GroupgroupColumnOptionalOptional sections: rows are grouped under a header with an on-target count.
    Trend periodperiodColumnOptionalOptional date or period field: draws a sparkline per row and aggregates the periods into the bullet.
    ActualvalueMeasureOptionalThe measured value (AC).
    TargettargetMeasureOptionalPlan, budget or goal (PL). Drives attainment, variance and status.
    ForecastforecastMeasureOptionalForecast or latest estimate (FC), drawn as a diamond.
    Prior yearpriorYearMeasureOptionalPrior year or previous period (PY), drawn as a dot.
    Axis minminValueMeasureOptionalOptional start of the axis per row.
    Axis maxmaxValueMeasureOptionalOptional end of the axis per row.
    Band boundary 1band1MeasureOptionalAbsolute boundary between the poor and satisfactory bands, per row.
    Band boundary 2band2MeasureOptionalAbsolute boundary between the satisfactory and good bands, per row.
    Lower is betterlowerIsBetterMeasureOptionalPer-row polarity: 1/true where a lower value is better (costs, defects, lead time).
    Elapsed %elapsedMeasureOptionalShare of the period already elapsed (0 to 1) for the run-rate projection.
    Unit or formatunitMeasureOptionalPer-row unit (%, days, kWh, €) or format string (0.0%) for mixed-unit scorecards. Use First or Max on a text column.
    TooltipstooltipsMeasureOptional · up to 5Extra measures shown in the tooltip.

    Themetheme

    SettingType and options
    ThemeselectedTheme
    • SmartVisuals smartvisuals
    • Dark dark
    • Clean (White) clean
    • Slate slate
    FontfontFamily
    • Inter inter
    • Segoe UI segoe
    • Arial arial
    • Georgia georgia
    Transparent backgroundtransparentBgOn / off
    Use report theme colorsuseReportThemeOn / off

    Layoutlayout

    SettingType and options
    Layoutmode
    • Rows rows
    • KPI tiles tiles
    Orientationorientation
    • Horizontal horizontal
    • Vertical vertical
    Axis scalescale
    • Per row row
    • Shared axis shared
    • % of target percent
    Groups asgroupLayout
    • Stacked sections sections
    • Side-by-side panels panels
    SortsortBy
    • Data order data
    • Worst first worst
    • Best first best
    • Largest gap first gap
    • Value, high to low valueDesc
    • Value, low to high valueAsc
    • Name, A to Z name
    Show top N (0 = all)topNNumber
    Others rowshowOthersOn / off
    Row height (0 = fit)rowHeightNumber
    Label width (0 = auto)labelWidthNumber
    Tile columns (0 = auto)tileColumnsNumber
    Column headersshowHeaderOn / off
    LegendshowLegendOn / off
    Legend positionlegendPosition
    • Top top
    • Bottom bottom

    Legendlegend

    SettingType and options
    LegendshowOn / off
    Legend positionposition
    • Top top
    • Bottom bottom

    Barsbars

    SettingType and options
    Color by statuscolorByStatusOn / off
    Bar colorbarColorColour
    GoodgoodColorColour
    SatisfactorywarnColorColour
    PoorbadColorColour
    Bar thickness % (0 = theme)barThicknessNumber

    Category colorsdataPoint

    SettingType and options
    ColorfillColour

    Bandsbands

    SettingType and options
    Show bandsshowOn / off
    Directionpolarity
    • Higher is better higher
    • Lower is better lower
    Band boundaries fromsource
    • % of target percent
    • Band boundary fields measures
    Poor below (% of target)threshold1Number
    Good from (% of target)threshold2Number
    Stretch band from (% of target, 0 = off)threshold3Number
    Stretch bandexcellentColorColour
    Poor bandpoorColorColour
    Satisfactory bandfairColorColour
    Good bandgoodBandColorColour

    Comparisonscomparisons

    SettingType and options
    Measure status againstprimary
    • Target target
    • Forecast forecast
    • Prior year priorYear
    Target marker shapetargetShape
    • Line line
    • Full-height line full
    • Line with arrows arrows
    • Triangle triangle
    Target markertargetColorColour
    Forecast markerforecastColorColour
    Prior-year markerpriorYearColorColour
    Prior-year stylepriorYearStyle
    • Dot dot
    • Bar behind actual bar
    Target labelshowTargetLabelOn / off
    Marker sizemarkerSizeNumber

    Values & variancevariance

    SettingType and options
    ValueshowValueOn / off
    Variancemode
    • Off none
    • Percent pct
    • Absolute abs
    • Absolute and percent both
    Notationnotation
    • Standard standard
    • IBCS (AC, PL, FC, PY) ibcs
    Variance barshowVarianceBarOn / off
    Variance pins columnshowPinsOn / off
    Status iconsshowStatusIconOn / off
    Display unitsdisplayUnits
    • Auto auto
    • None none
    • Thousands thousands
    • Millions millions
    • Billions billions
    Decimal placesdecimalsNumber

    Pace & projectionpace

    SettingType and options
    Period elapsedperiod
    • Off none
    • Year to date (today) year
    • Quarter to date (today) quarter
    • Month to date (today) month
    • Fixed % fixed
    • Elapsed % field measure
    Elapsed %fixedElapsedNumber
    Run-rate projectionshowProjectionOn / off
    Expected-to-date markershowExpectedOn / off
    Pace marker colorprojectionColorColour

    Trendtrend

    SettingType and options
    SparklineshowOn / off
    Bullet showsaggregation
    • Auto auto
    • Latest period latest
    • Sum of periods sum
    • Average of periods average
    Sparkline colorcolorColour
    Target line in sparklineshowTargetLineOn / off

    Labelslabels

    SettingType and options
    Font sizefontSizeNumber
    Font colorfontColorColour
    Category labelsshowCategoryOn / off
    Secondary text colorsecondaryColorColour

    Axis & gridaxis

    SettingType and options
    Axis labelsshowAxisOn / off
    Tick labels on every rowrowTicksOn / off
    GridlinesshowGridOn / off
    Grid colorgridColorColour
    Round axis endniceAxisOn / off

    Smart insightsinsights

    SettingType and options
    Summary sentenceshowOn / off

    Accessibilityaccessibility

    SettingType and options
    Focus outline colorfocusColorColour
    Focus outline width (0 = theme)focusWidthNumber
    Minimum text size (0 = off)minFontSizeNumber

    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": "bulletChart51B8721E840648AA92DA8EB0B9053DBC",
  "objects": {
    "theme": [{
      "properties": {
        "transparentBg": { "expr": { "Literal": { "Value": "true" } } }
      }
    }]
  }
}