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

    14 fields · 25 cards · 175 settings Markdown for AI assistantscatalog.json

    Fields

    FieldTakesNeededWhat it is for
    CategorycategoryColumnOptionalThe bars: sites, products, months. Add several fields to drill down.
    ValuesvaluesMeasureOptionalOne or more measures; several measures are clustered, stacked or compared side by side.
    LegendlegendColumnOptionalSplits each bar into segments (stacked) or series (clustered).
    Small multiplesfacetColumnOptionalOne small chart per value of this field.
    Date (previous year)periodColumnOptionalA date field: the visual sums the current period and the same period a year earlier (premium comparison).
    Previous yearpyMeasureOptionalOptional: your own previous-year measure (otherwise derived from the date).
    Plan / budgetplanMeasureOptionalCompared with the actual as an outlined bar and variance (premium).
    ForecastforecastMeasureOptionalCompared with the actual as a hatched bar and variance (premium).
    TargettargetMeasureOptionalA marker on every bar (free).
    Error bar: lowererrLowMeasureOptionalLower bound (or distance below) of an error bar.
    Error bar: uppererrHighMeasureOptionalUpper bound (or distance above) of an error bar.
    AnnotationannotationMeasureOptionalA text measure drawn as a note on its bar.
    Icon or imageimageMeasureOptionalAn emoji, a short text or a data:image URI per category, shown next to its label.
    TooltipstooltipsMeasureOptionalExtra measures in the tooltip.

    Style templatepresets

    SettingType and options
    Style templatetemplate
    • None (defaults) none
    • Executive executive
    • IBCS (finance) ibcs
    • Minimal minimal
    • Presentation presentation
    • Print print
    • Custom custom
    AppliedappliedText
    Style as JSONjsonText

    Layoutlayout

    SettingType and options
    Chart typelayout
    • Clustered clustered
    • Stacked stacked
    • 100 % stacked percent
    • Overlapped (lipstick) overlapped
    • Lollipop lollipop
    • Dumbbell dumbbell
    • Population pyramid (back to back) pyramid
    • Clustered and stacked clusteredStacked
    Orientationorientation
    • Automatic (dates as columns, categories as bars) auto
    • Columns (vertical) column
    • Bars (horizontal) bar
    Bar shapeshape
    • From theme theme
    • Square square
    • Rounded rounded
    • Pill pill
    Gap between categories (%)gapNumber
    Gap between series (%)innerGapNumber
    Minimum bar thickness (px)minThicknessNumber
    Hide zero and blank categorieshideZeroOn / off
    Total bartotalBarOn / off
    Total labeltotalLabelText
    Responsive layoutresponsiveOn / off

    Sortingsorting

    SettingType and options
    Sort byby
    • Automatic (dates in time order, else largest first) auto
    • Data order (visual header sort) none
    • Value, largest first valueDesc
    • Value, smallest first valueAsc
    • Name, A to Z nameAsc
    • Name, Z to A nameDesc
    • A legend segment segment
    • Variance to comparison variance
    Segment to sort bysegmentText
    Stacking orderstackOrder
    • Legend order legend
    • Largest segment at the base sizeDesc
    • Smallest segment at the base sizeAsc
    Let readers change the sortreaderSortOn / off
    Sort button text sizebuttonFontSizeNumber

    Top NtopN

    SettingType and options
    Show Top N onlyshowOn / off
    Number of categoriescountNumber
    Keepmode
    • Largest values top
    • Smallest values bottom
    Group the rest as OtherotherOn / off
    Other labelotherLabelText

    Small multiplessmallMultiples

    SettingType and options
    Columns (0 = automatic)columnsNumber
    Shared value axissharedAxisOn / off
    Same category order in every panelsharedOrderOn / off
    Panel titlesshowTitlesOn / off
    Panel title sizetitleSizeNumber
    Panel title colourtitleColorColour

    Data labelslabels

    SettingType and options
    Show data labelsshowOn / off
    Contentcontent
    • Value value
    • % of category percent
    • Value and % of category valueAndPercent
    • % of total percentTotal
    Positionposition
    • Automatic auto
    • Inside end inside
    • Outside end outside
    • Inside base base
    Text sizefontSizeNumber
    ColourcolorColour
    Display unitsunits
    • Auto auto
    • None none
    • Thousands K
    • Millions M
    • Billions B
    Decimal places (-1 = automatic)decimalsNumber
    Hide segment labels below (% of category)hideBelowNumber
    Total labels on stackstotalsOn / off
    Label backgroundbackgroundOn / off
    Background colourbackgroundColorColour
    Change % to the previous barprevChangeOn / off

    Value axisvalueAxis

    SettingType and options
    Show value axisshowOn / off
    Scale typescale
    • Linear linear
    • Logarithmic log
    Axis titleshowTitleOn / off
    Title texttitleText
    StartminText
    EndmaxText
    Display unitsunits
    • Auto auto
    • None none
    • Thousands K
    • Millions M
    • Billions B
    Decimal places (-1 = automatic)decimalsNumber
    Text sizefontSizeNumber
    ColourcolorColour
    Axis break for an outsized baraxisBreakOn / off

    Category axiscategoryAxis

    SettingType and options
    Show category axisshowOn / off
    Axis titleshowTitleOn / off
    Title texttitleText
    Text sizefontSizeNumber
    ColourcolorColour
    Maximum label width (% of the visual)maxWidthNumber
    Column label rotationrotate
    • Automatic auto
    • Horizontal 0
    • 45 degrees 45
    • Vertical 90
    Show icons or imagesiconsOn / off
    Rank change vs previous yearrankChangeOn / off

    Legendlegend

    SettingType and options
    Show legendshowOn / off
    Positionposition
    • Top top
    • Bottom bottom
    • Left left
    • Right right
    TitleshowTitleOn / off
    Title texttitleTextText
    Text sizefontSizeNumber
    ColourcolorColour

    Gridlinesgridlines

    SettingType and options
    Show gridlinesshowOn / off
    Stylestyle
    • From theme theme
    • Solid solid
    • Dashed dashed
    • Dotted dotted
    ColourcolorColour
    WidthwidthNumber

    Data point markersmarkers

    SettingType and options
    Shapeshape
    • Circle circle
    • Square square
    • Diamond diamond
    SizesizeNumber
    Stem widthstemWidthNumber

    Colour rulescolorRules

    SettingType and options
    Highlight the highest barhighlightMaxOn / off
    Highest colourmaxColorColour
    Highlight the lowest barhighlightMinOn / off
    Lowest colourminColorColour
    Values aboveaboveText
    Colour aboveaboveColorColour
    Values belowbelowText
    Colour belowbelowColorColour
    Dim bars no rule matchesdimOthersOn / off

    Targettarget

    SettingType and options
    Show target markersshowOn / off
    Markerstyle
    • Tick across the bar tick
    • Dot dot
    • Line through the bars line
    ColourcolorColour
    WidthwidthNumber
    Target labelslabelsOn / off
    Target label sizelabelSizeNumber
    Mark bars below targetstateOn / off

    Error barserrorBars

    SettingType and options
    Show error barsshowOn / off
    Fields aremode
    • Lower and upper bounds bounds
    • Distances below and above deltas
    ColourcolorColour
    WidthwidthNumber

    Annotationsannotations

    SettingType and options
    Show annotationsshowOn / off
    Note 1 categorycategory1Text
    Note 1 texttext1Text
    Note 2 categorycategory2Text
    Note 2 texttext2Text
    Text sizefontSizeNumber
    ColourcolorColour

    Difference highlightdifference

    SettingType and options
    Show the difference between two barsshowOn / off
    From categoryfromText
    To categorytoText
    Show CAGR (dates)cagrOn / off
    ColourcolorColour
    Show the labelshowLabelOn / off
    Text sizefontSizeNumber

    Reference linesrefLines

    SettingType and options
    Line 1line1
    • None none
    • A value value
    • Average average
    • Median median
    • Percentile percentile
    • Minimum min
    • Maximum max
    Line 1 valueline1ValueNumber
    Line 1 percentileline1PercentileNumber
    Line 1 labelline1LabelText
    Line 1 colourline1ColorColour
    Line 1 styleline1Dash
    • Solid solid
    • Dashed dashed
    • Dotted dotted
    Line 2line2
    • None none
    • A value value
    • Average average
    • Median median
    • Percentile percentile
    • Minimum min
    • Maximum max
    Line 2 valueline2ValueNumber
    Line 2 percentileline2PercentileNumber
    Line 2 labelline2LabelText
    Line 2 colourline2ColorColour
    Line 2 styleline2Dash
    • Solid solid
    • Dashed dashed
    • Dotted dotted
    Line 3line3
    • None none
    • A value value
    • Average average
    • Median median
    • Percentile percentile
    • Minimum min
    • Maximum max
    Line 3 valueline3ValueNumber
    Line 3 percentileline3PercentileNumber
    Line 3 labelline3LabelText
    Line 3 colourline3ColorColour
    Line 3 styleline3Dash
    • Solid solid
    • Dashed dashed
    • Dotted dotted
    Reference bandbandOn / off
    Band frombandFromNumber
    Band tobandToNumber
    Band colourbandColorColour
    Band labelbandLabelText
    Show labelsshowLabelsOn / off
    Label text sizelabelSizeNumber
    Label colourlabelColorColour

    Trend linetrend

    SettingType and options
    Show linear trendshowOn / off
    ColourcolorColour
    Styledash
    • Solid solid
    • Dashed dashed
    • Dotted dotted
    Show slope and R²showR2On / off
    Label text sizelabelSizeNumber

    Pareto linepareto

    SettingType and options
    Show cumulative % lineshowOn / off
    ColourcolorColour
    Mark the 80 % pointmark80On / off
    Show the % scaleshowPercentOn / off
    Label text sizelabelSizeNumber

    Comparison & variancecompare

    SettingType and options
    Compare (premium)showOn / off
    Previous yearpyOn / off
    Plan / budgetplanOn / off
    ForecastforecastOn / off
    Period of the Date fieldwindow
    • Year to date ytd
    • Latest full year year
    • Latest quarter quarter
    • Latest month month
    Comparison shown asdisplay
    • Ghost bar behind ghost
    • Overlapping bar overlap
    • Bar beside side
    • Marker marker
    Variance chartsvariance
    • None none
    • Δ (absolute) abs
    • Δ% (pins) pct
    • Δ and Δ% both
    Variance againstvarianceOf
    • Automatic (plan, else previous year) auto
    • Previous year py
    • Plan / budget plan
    • Forecast forecast
    Second variance chartsecondOn / off
    Variance chart titlesvarianceTitlesOn / off
    Variance labelsvarianceLabelsOn / off
    Variance text sizevarianceFontSizeNumber
    Colour bars by met / missedmetColorsOn / off
    Lower is better (costs)lowerIsBetterOn / off
    IBCS notationibcsOn / off

    Narrativenarrative

    SettingType and options
    One-line captioncaptionOn / off
    Findings panel (premium)findingsOn / off
    Findings positionposition
    • Automatic auto
    • Right right
    • Bottom bottom
    Text sizefontSizeNumber
    ColourcolorColour

    Accessibilityaccessibility

    SettingType and options
    Focus outline colourfocusColorColour
    Focus outline widthfocusWidthNumber
    Minimum text sizeminFontSizeNumber
    Distinguish series without colourdistinguishOn / off
    Grow animationanimateOn / off
    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

    Series coloursseriesColors

    SettingType and options
    ColourfillColour

    Data coloursdataPoint

    SettingType and options
    ColourfillColour

    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": "smartvisualsBarColumnF2A5014294BBEC264697AC4285A0A1D4",
      "objects": {
        "layout": [{
          "properties": {
            "hideZero": { "expr": { "Literal": { "Value": "true" } } }
          }
        }]
      }
    }