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

    9 fields · 20 cards · 109 settings Markdown for AI assistantscatalog.json

    Fields

    FieldTakesNeededWhat it is for
    Axis (date)axisColumnOptionalThe time axis: a date, a date hierarchy level, a number or text periods
    OpenopenMeasureOptionalOpening value of each period (candles)
    HighhighMeasureOptionalHighest value of each period (candles), or the top of a range band
    LowlowMeasureOptionalLowest value of each period (candles), or the bottom of a range band
    ClosecloseMeasureOptionalClosing value of each period (candles)
    VolumevolumeMeasureOptionalTraded volume per period (volume pane)
    AnnotationannotationMeasureOptionalText measure: a non-blank value pins a note on that period
    Small multiplesfacetColumnOptionalOne panel per value (premium)
    TooltipstooltipsMeasureOptionalExtra fields in tooltips

    Presets and Templatespresets

    SettingType and options
    Apply Presetpreset
    • (choose to apply) none
    • Executive executive
    • Finance (IBCS) finance
    • Trading trading
    • Monitoring monitoring
    • Print print
    Style Template (copy or paste)templateText

    Candlescandles

    SettingType and options
    Stylestyle
    • Candles candle
    • Hollow candles hollow
    • OHLC bars ohlc
    • Heikin-Ashi heikin
    • Renko renko
    • Close line line
    • Close area area
    Up ColourupColorColour
    Down ColourdownColorColour
    Brick Size (0 = ATR)brickSizeNumber
    Volume PaneshowVolumeOn / off
    Volume Pane Height (%)volumeHeightNumber
    Show Calendar GapscalendarGapsOn / off
    Flag Invalid BarsvalidateOn / off

    Indicatorsindicators

    SettingType and options
    Moving Average 1 Periods (0 = off)ma1Number
    Moving Average 1 Typema1Type
    • SMA sma
    • EMA ema
    • WMA wma
    Moving Average 2 Periods (0 = off)ma2Number
    Moving Average 2 Typema2Type
    • SMA sma
    • EMA ema
    • WMA wma
    Moving Average 3 Periods (0 = off)ma3Number
    Moving Average 3 Typema3Type
    • SMA sma
    • EMA ema
    • WMA wma
    Bollinger BandsbollingerOn / off
    Bollinger PeriodsbollPeriodNumber
    Bollinger Width (σ)bollMultNumber
    VWAPvwapOn / off
    RSI PanersiOn / off
    MACD PanemacdOn / off
    Stochastic PanestochasticOn / off
    ATR PaneatrOn / off
    Pivot LevelspivotsOn / off

    Trend Linetrend

    SettingType and options
    Typetype
    • None none
    • Linear linear
    • Polynomial (2nd order) poly2
    • Polynomial (3rd order) poly3
    • Polynomial (4th order) poly4
    • Exponential exponential
    • Logarithmic logarithmic
    • Power power
    • LOESS (smooth) loess
    • Simple moving average sma
    • Exponential moving average ema
    • Weighted moving average wma
    Moving Average PeriodswindowNumber
    LOESS Span (%)spanNumber
    For Every SeriesallSeriesOn / off
    Line Styledash
    • Solid solid
    • Dashed dashed
    • Dotted dotted
    • Dash-dot dashdot
    Equation and R² in LegendshowEquationOn / off

    Forecastforecast

    SettingType and options
    Show ForecastshowOn / off
    Periods Ahead (0 = one season)horizonNumber
    Or Forecast Through (yyyy-mm-dd)throughText
    Modelmodel
    • Automatic (lowest AICc) auto
    • Simple exponential smoothing ANN
    • Holt linear trend AAN
    • Damped trend AAdN
    • Seasonal, no trend ANA
    • Holt-Winters additive AAA
    • Holt-Winters damped AAdA
    Season Length (0 = from dates)seasonNumber
    Prediction Intervallevel
    • None none
    • 80 % 80
    • 95 % 95
    • 80 % and 95 % both
    Mark AnomaliesanomaliesOn / off
    For Every SeriesallSeriesOn / off

    X-AxisxAxis

    SettingType and options
    ShowshowOn / off
    TitleshowTitleOn / off
    Font SizefontSizeNumber
    ColourcolorColour
    Vertical GridlinesgridOn / off

    Y-AxisyAxis

    SettingType and options
    ShowshowOn / off
    TitleshowTitleOn / off
    Minimum (blank = auto)minText
    Maximum (blank = auto)maxText
    Start At Zerozero
    • Automatic (columns and areas) auto
    • Always always
    • Never never
    Logarithmic ScalelogOn / off
    Decimals (-1 = auto)decimalsNumber
    Font SizefontSizeNumber
    ColourcolorColour
    Align Zero Across AxesalignOn / off

    Gridlinesgridlines

    SettingType and options
    Stylestyle
    • From theme theme
    • Solid solid
    • Dashed dashed
    • Dotted dotted
    • Zebra bands bands
    • None none
    ColourcolorColour

    Legendlegend

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

    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 Percentileline1PctNumber
    Line 1 Labelline1LabelText
    Line 1 Colourline1ColorColour
    Line 2line2
    • None none
    • A value value
    • Average average
    • Median median
    • Percentile percentile
    • Minimum min
    • Maximum max
    Line 2 Valueline2ValueNumber
    Line 2 Percentileline2PctNumber
    Line 2 Labelline2LabelText
    Line 2 Colourline2ColorColour
    For Every SeriesperSeriesOn / off
    Vertical Linevertical
    • None none
    • Today today
    • A date date
    Vertical Line Date (yyyy-mm-dd)verticalDateText
    Vertical Line LabelverticalLabelText

    Reference BandsrefBands

    SettingType and options
    Value Band FromvalueFromText
    Value Band TovalueToText
    Value Band LabelvalueLabelText
    Value Band ColourvalueColorColour
    Period From (yyyy-mm-dd)timeFromText
    Period To (yyyy-mm-dd)timeToText
    Period LabeltimeLabelText
    Period ColourtimeColorColour

    Annotationsannotations

    SettingType and options
    Stylestyle
    • Pin with label pin
    • Flag on the axis flag
    • Numbered, listed in the footnote numbered
    Shade Until the Next AnnotationshadeUntilNextOn / off
    Font SizefontSizeNumber
    ColourcolorColour

    Zoomnavigator

    SettingType and options
    Range NavigatorshowOn / off
    Navigator HeightheightNumber
    Ctrl + Wheel Zooms, Drag PanswheelOn / off

    Small MultiplessmallMultiples

    SettingType and options
    Columns (0 = auto)columnsNumber
    Shared Y-AxissharedYOn / off

    Smart Captioncaption

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

    Footnotefootnote

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

    Accessibilityaccessibility

    SettingType and options
    Distinguish Series Without ColourdistinguishOn / off
    Focus Outline ColourfocusColorColour
    Focus Outline WidthfocusWidthNumber
    Minimum Text Size (0 = off)minFontSizeNumber

    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": "smartvisualsCandlestickF985EF292C630D0F21DE96AC286EF0EE",
      "objects": {
        "candles": [{
          "properties": {
            "showVolume": { "expr": { "Literal": { "Value": "true" } } }
          }
        }]
      }
    }