Line Chart 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 Line Chart page; every setting works in edit mode with or without one.
11 fields · 33 cards · 146 settings Markdown for AI assistantscatalog.json
Fields
| Field | Takes | Needed | What it is for |
|---|---|---|---|
Axis (date)axis | Column | Optional | The time axis: a date, a date hierarchy level, a number or text periods |
Legendlegend | Column | Optional | One series per value (one row per value in Sparklines) |
Valuesvalues | Measure | Optional | Measures drawn as lines, areas or sparklines |
Secondary axis valuessecondary | Measure | Optional | Measures drawn on the right-hand axis |
Targettarget | Measure | Optional | Plan, budget or target: a dashed series and the base for variances |
Comparisoncomparison | Measure | Optional | Previous year or any comparison series from the model |
Highhigh | Measure | Optional | Highest value of each period (candles), or the top of a range band |
Lowlow | Measure | Optional | Lowest value of each period (candles), or the bottom of a range band |
Annotationannotation | Measure | Optional | Text measure: a non-blank value pins a note on that period |
Small multiplesfacet | Column | Optional | One panel per value (premium) |
Tooltipstooltips | Measure | Optional | Extra fields in tooltips |
Presets and Templatespresets
| Setting | Type and options |
|---|---|
Apply Presetpreset |
|
Style Template (copy or paste)template | Text |
Lineslines
| Setting | Type and options |
|---|---|
Line Shapeinterpolation |
|
Line Width (0 = theme)width | Number |
Missing Valuesmissing |
|
Show Values AsshowAs |
|
Fiscal Year Starts In MonthfiscalStart | Number |
Moving Sum Periodswindow | Number |
Show Top N Series (0 = all)topN | Number |
Other Seriesothers |
|
Markersmarkers
| Setting | Type and options |
|---|---|
Show Markersshow |
|
Shapeshape |
|
Sizesize | Number |
Data Labelslabels
| Setting | Type and options |
|---|---|
Showshow |
|
Label Every Nth Pointevery | Number |
Decimals (-1 = auto)decimals | Number |
Font SizefontSize | Number |
Colourcolor | Colour |
Background Pillbackground | On / off |
End-of-Line LabelsendLabels
| Setting | Type and options |
|---|---|
Showshow | On / off |
Contentcontent |
|
Font SizefontSize | Number |
Up To N Series (more: legend)maxSeries | Number |
Highlightshighlights
| Setting | Type and options |
|---|---|
Mark Maximummax | On / off |
Mark Minimummin | On / off |
Mark Peaks and Troughspeaks | On / off |
Peak Prominence (% of range)prominence | Number |
Threshold Colouringthreshold
| Setting | Type and options |
|---|---|
Colour Above / Belowshow | On / off |
Thresholdsource |
|
Valuevalue | Number |
Above ColouraboveColor | Colour |
Below ColourbelowColor | Colour |
Difference Filldifference
| Setting | Type and options |
|---|---|
Fill Between Two Seriesshow | On / off |
Compare Withagainst |
|
Higher Is BetterhigherIsBetter | On / off |
Better ColourgoodColor | Colour |
Worse ColourbadColor | Colour |
Range Bandband
| Setting | Type and options |
|---|---|
Show Low-High Bandshow | On / off |
Colourcolor | Colour |
Opacity (%)opacity | Number |
Edge Linesedges | On / off |
Actual and Forecast Stylingactual
| Setting | Type and options |
|---|---|
Actuals End Atthrough |
|
Date (yyyy-mm-dd)date | Text |
Vertical Rulerule | On / off |
Rule LabelruleLabel | Text |
Trend Linetrend
| Setting | Type and options |
|---|---|
Typetype |
|
Moving Average Periodswindow | Number |
LOESS Span (%)span | Number |
For Every SeriesallSeries | On / off |
Line Styledash |
|
Equation and R² in LegendshowEquation | On / off |
Forecastforecast
| Setting | Type and options |
|---|---|
Show Forecastshow | On / off |
Periods Ahead (0 = one season)horizon | Number |
Or Forecast Through (yyyy-mm-dd)through | Text |
Modelmodel |
|
Season Length (0 = from dates)season | Number |
Prediction Intervallevel |
|
Mark Anomaliesanomalies | On / off |
For Every SeriesallSeries | On / off |
Comparecompare
| Setting | Type and options |
|---|---|
Compare Withbase |
|
Show the Comparison Lineghost | On / off |
Variance BandvarianceBand | On / off |
Variance BarsvarianceBars |
|
Higher Is BetterhigherIsBetter | On / off |
Trend TesttrendTest
| Setting | Type and options |
|---|---|
Test for a Trend (Mann-Kendall)show | On / off |
Significance Levelalpha |
|
Seasonal Decompositiondecomposition
| Setting | Type and options |
|---|---|
Trend, Seasonal and Remaindershow | On / off |
Season Length (0 = from dates)season | Number |
X-AxisxAxis
| Setting | Type and options |
|---|---|
Showshow | On / off |
TitleshowTitle | On / off |
Font SizefontSize | Number |
Colourcolor | Colour |
Vertical Gridlinesgrid | On / off |
Y-AxisyAxis
| Setting | Type and options |
|---|---|
Showshow | On / off |
TitleshowTitle | On / off |
Minimum (blank = auto)min | Text |
Maximum (blank = auto)max | Text |
Start At Zerozero |
|
Logarithmic Scalelog | On / off |
Decimals (-1 = auto)decimals | Number |
Font SizefontSize | Number |
Colourcolor | Colour |
Align Zero Across Axesalign | On / off |
Secondary Y-Axesy2Axis
| Setting | Type and options |
|---|---|
Showshow | On / off |
TitleshowTitle | On / off |
Minimum (blank = auto)min | Text |
Maximum (blank = auto)max | Text |
Logarithmic Scalelog | On / off |
Colour Each Axis Like Its SeriescolorByAxis | On / off |
Gridlinesgridlines
| Setting | Type and options |
|---|---|
Stylestyle |
|
Colourcolor | Colour |
Legendlegend
| Setting | Type and options |
|---|---|
Showshow | On / off |
Positionposition |
|
Font SizefontSize | Number |
Text Colourcolor | Colour |
Reference LinesrefLines
| Setting | Type and options |
|---|---|
Line 1line1 |
|
Line 1 Valueline1Value | Number |
Line 1 Percentileline1Pct | Number |
Line 1 Labelline1Label | Text |
Line 1 Colourline1Color | Colour |
Line 2line2 |
|
Line 2 Valueline2Value | Number |
Line 2 Percentileline2Pct | Number |
Line 2 Labelline2Label | Text |
Line 2 Colourline2Color | Colour |
For Every SeriesperSeries | On / off |
Vertical Linevertical |
|
Vertical Line Date (yyyy-mm-dd)verticalDate | Text |
Vertical Line LabelverticalLabel | Text |
Reference BandsrefBands
| Setting | Type and options |
|---|---|
Value Band FromvalueFrom | Text |
Value Band TovalueTo | Text |
Value Band LabelvalueLabel | Text |
Value Band ColourvalueColor | Colour |
Period From (yyyy-mm-dd)timeFrom | Text |
Period To (yyyy-mm-dd)timeTo | Text |
Period LabeltimeLabel | Text |
Period ColourtimeColor | Colour |
Annotationsannotations
| Setting | Type and options |
|---|---|
Stylestyle |
|
Shade Until the Next AnnotationshadeUntilNext | On / off |
Font SizefontSize | Number |
Colourcolor | Colour |
Small MultiplessmallMultiples
| Setting | Type and options |
|---|---|
Columns (0 = auto)columns | Number |
Shared Y-AxissharedY | On / off |
Smart Captioncaption
| Setting | Type and options |
|---|---|
Showshow | On / off |
Positionposition |
|
Font SizefontSize | Number |
Text Colourcolor | Colour |
Footnotefootnote
| Setting | Type and options |
|---|---|
Showshow | On / off |
Sourcesource | Text |
State the MethodsshowMethod | On / off |
Font SizefontSize | Number |
Text Colourcolor | Colour |
Accessibilityaccessibility
| Setting | Type and options |
|---|---|
Distinguish Series Without Colourdistinguish | On / off |
Focus Outline ColourfocusColor | Colour |
Focus Outline WidthfocusWidth | Number |
Minimum Text Size (0 = off)minFontSize | Number |
Themetheme
| Setting | Type and options |
|---|---|
ThemeselectedTheme |
|
Fontfont |
|
Transparent BackgroundtransparentBg | On / off |
Series ColoursseriesColors
| Setting | Type and options |
|---|---|
Colourfill | Colour |
Series AxesseriesAxis
| Setting | Type and options |
|---|---|
Axisaxis |
|
Series Line StylesseriesStyle
| Setting | Type and options |
|---|---|
Line Styledash |
|
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": "smartvisualsLineChart397311D2BC031916022BF9AD311F194B",
"objects": {
"labels": [{
"properties": {
"background": { "expr": { "Literal": { "Value": "true" } } }
}
}]
}
}