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
| Field | Takes | Needed | What it is for |
|---|---|---|---|
Categorycategory | Column | Optional | The bars: sites, products, months. Add several fields to drill down. |
Valuesvalues | Measure | Optional | One or more measures; several measures are clustered, stacked or compared side by side. |
Legendlegend | Column | Optional | Splits each bar into segments (stacked) or series (clustered). |
Small multiplesfacet | Column | Optional | One small chart per value of this field. |
Date (previous year)period | Column | Optional | A date field: the visual sums the current period and the same period a year earlier (premium comparison). |
Previous yearpy | Measure | Optional | Optional: your own previous-year measure (otherwise derived from the date). |
Plan / budgetplan | Measure | Optional | Compared with the actual as an outlined bar and variance (premium). |
Forecastforecast | Measure | Optional | Compared with the actual as a hatched bar and variance (premium). |
Targettarget | Measure | Optional | A marker on every bar (free). |
Error bar: lowererrLow | Measure | Optional | Lower bound (or distance below) of an error bar. |
Error bar: uppererrHigh | Measure | Optional | Upper bound (or distance above) of an error bar. |
Annotationannotation | Measure | Optional | A text measure drawn as a note on its bar. |
Icon or imageimage | Measure | Optional | An emoji, a short text or a data:image URI per category, shown next to its label. |
Tooltipstooltips | Measure | Optional | Extra measures in the tooltip. |
Style templatepresets
| Setting | Type and options |
|---|---|
Style templatetemplate |
|
Appliedapplied | Text |
Style as JSONjson | Text |
Layoutlayout
| Setting | Type and options |
|---|---|
Chart typelayout |
|
Orientationorientation |
|
Bar shapeshape |
|
Gap between categories (%)gap | Number |
Gap between series (%)innerGap | Number |
Minimum bar thickness (px)minThickness | Number |
Hide zero and blank categorieshideZero | On / off |
Total bartotalBar | On / off |
Total labeltotalLabel | Text |
Responsive layoutresponsive | On / off |
Sortingsorting
| Setting | Type and options |
|---|---|
Sort byby |
|
Segment to sort bysegment | Text |
Stacking orderstackOrder |
|
Let readers change the sortreaderSort | On / off |
Sort button text sizebuttonFontSize | Number |
Top NtopN
| Setting | Type and options |
|---|---|
Show Top N onlyshow | On / off |
Number of categoriescount | Number |
Keepmode |
|
Group the rest as Otherother | On / off |
Other labelotherLabel | Text |
Small multiplessmallMultiples
| Setting | Type and options |
|---|---|
Columns (0 = automatic)columns | Number |
Shared value axissharedAxis | On / off |
Same category order in every panelsharedOrder | On / off |
Panel titlesshowTitles | On / off |
Panel title sizetitleSize | Number |
Panel title colourtitleColor | Colour |
Data labelslabels
| Setting | Type and options |
|---|---|
Show data labelsshow | On / off |
Contentcontent |
|
Positionposition |
|
Text sizefontSize | Number |
Colourcolor | Colour |
Display unitsunits |
|
Decimal places (-1 = automatic)decimals | Number |
Hide segment labels below (% of category)hideBelow | Number |
Total labels on stackstotals | On / off |
Label backgroundbackground | On / off |
Background colourbackgroundColor | Colour |
Change % to the previous barprevChange | On / off |
Value axisvalueAxis
| Setting | Type and options |
|---|---|
Show value axisshow | On / off |
Scale typescale |
|
Axis titleshowTitle | On / off |
Title texttitle | Text |
Startmin | Text |
Endmax | Text |
Display unitsunits |
|
Decimal places (-1 = automatic)decimals | Number |
Text sizefontSize | Number |
Colourcolor | Colour |
Axis break for an outsized baraxisBreak | On / off |
Category axiscategoryAxis
| Setting | Type and options |
|---|---|
Show category axisshow | On / off |
Axis titleshowTitle | On / off |
Title texttitle | Text |
Text sizefontSize | Number |
Colourcolor | Colour |
Maximum label width (% of the visual)maxWidth | Number |
Column label rotationrotate |
|
Show icons or imagesicons | On / off |
Rank change vs previous yearrankChange | On / off |
Legendlegend
| Setting | Type and options |
|---|---|
Show legendshow | On / off |
Positionposition |
|
TitleshowTitle | On / off |
Title texttitleText | Text |
Text sizefontSize | Number |
Colourcolor | Colour |
Gridlinesgridlines
| Setting | Type and options |
|---|---|
Show gridlinesshow | On / off |
Stylestyle |
|
Colourcolor | Colour |
Widthwidth | Number |
Data point markersmarkers
| Setting | Type and options |
|---|---|
Shapeshape |
|
Sizesize | Number |
Stem widthstemWidth | Number |
Colour rulescolorRules
| Setting | Type and options |
|---|---|
Highlight the highest barhighlightMax | On / off |
Highest colourmaxColor | Colour |
Highlight the lowest barhighlightMin | On / off |
Lowest colourminColor | Colour |
Values aboveabove | Text |
Colour aboveaboveColor | Colour |
Values belowbelow | Text |
Colour belowbelowColor | Colour |
Dim bars no rule matchesdimOthers | On / off |
Targettarget
| Setting | Type and options |
|---|---|
Show target markersshow | On / off |
Markerstyle |
|
Colourcolor | Colour |
Widthwidth | Number |
Target labelslabels | On / off |
Target label sizelabelSize | Number |
Mark bars below targetstate | On / off |
Error barserrorBars
| Setting | Type and options |
|---|---|
Show error barsshow | On / off |
Fields aremode |
|
Colourcolor | Colour |
Widthwidth | Number |
Annotationsannotations
| Setting | Type and options |
|---|---|
Show annotationsshow | On / off |
Note 1 categorycategory1 | Text |
Note 1 texttext1 | Text |
Note 2 categorycategory2 | Text |
Note 2 texttext2 | Text |
Text sizefontSize | Number |
Colourcolor | Colour |
Difference highlightdifference
| Setting | Type and options |
|---|---|
Show the difference between two barsshow | On / off |
From categoryfrom | Text |
To categoryto | Text |
Show CAGR (dates)cagr | On / off |
Colourcolor | Colour |
Show the labelshowLabel | On / off |
Text sizefontSize | Number |
Reference linesrefLines
| Setting | Type and options |
|---|---|
Line 1line1 |
|
Line 1 valueline1Value | Number |
Line 1 percentileline1Percentile | Number |
Line 1 labelline1Label | Text |
Line 1 colourline1Color | Colour |
Line 1 styleline1Dash |
|
Line 2line2 |
|
Line 2 valueline2Value | Number |
Line 2 percentileline2Percentile | Number |
Line 2 labelline2Label | Text |
Line 2 colourline2Color | Colour |
Line 2 styleline2Dash |
|
Line 3line3 |
|
Line 3 valueline3Value | Number |
Line 3 percentileline3Percentile | Number |
Line 3 labelline3Label | Text |
Line 3 colourline3Color | Colour |
Line 3 styleline3Dash |
|
Reference bandband | On / off |
Band frombandFrom | Number |
Band tobandTo | Number |
Band colourbandColor | Colour |
Band labelbandLabel | Text |
Show labelsshowLabels | On / off |
Label text sizelabelSize | Number |
Label colourlabelColor | Colour |
Trend linetrend
| Setting | Type and options |
|---|---|
Show linear trendshow | On / off |
Colourcolor | Colour |
Styledash |
|
Show slope and R²showR2 | On / off |
Label text sizelabelSize | Number |
Pareto linepareto
| Setting | Type and options |
|---|---|
Show cumulative % lineshow | On / off |
Colourcolor | Colour |
Mark the 80 % pointmark80 | On / off |
Show the % scaleshowPercent | On / off |
Label text sizelabelSize | Number |
Comparison & variancecompare
| Setting | Type and options |
|---|---|
Compare (premium)show | On / off |
Previous yearpy | On / off |
Plan / budgetplan | On / off |
Forecastforecast | On / off |
Period of the Date fieldwindow |
|
Comparison shown asdisplay |
|
Variance chartsvariance |
|
Variance againstvarianceOf |
|
Second variance chartsecond | On / off |
Variance chart titlesvarianceTitles | On / off |
Variance labelsvarianceLabels | On / off |
Variance text sizevarianceFontSize | Number |
Colour bars by met / missedmetColors | On / off |
Lower is better (costs)lowerIsBetter | On / off |
IBCS notationibcs | On / off |
Narrativenarrative
| Setting | Type and options |
|---|---|
One-line captioncaption | On / off |
Findings panel (premium)findings | On / off |
Findings positionposition |
|
Text sizefontSize | Number |
Colourcolor | Colour |
Accessibilityaccessibility
| Setting | Type and options |
|---|---|
Focus outline colourfocusColor | Colour |
Focus outline widthfocusWidth | Number |
Minimum text sizeminFontSize | Number |
Distinguish series without colourdistinguish | On / off |
Grow animationanimate | On / off |
Reduce motionreduceMotion | On / off |
Themetheme
| Setting | Type and options |
|---|---|
ThemeselectedTheme |
|
Fontfont |
|
Transparent backgroundtransparentBg | On / off |
Series coloursseriesColors
| Setting | Type and options |
|---|---|
Colourfill | Colour |
Data coloursdataPoint
| Setting | Type and options |
|---|---|
Colourfill | Colour |
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" } } }
}
}]
}
}