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

    6 fields · 7 cards · 35 settings Markdown for AI assistantscatalog.json

    Fields

    FieldTakesNeededWhat it is for
    QuestionquestionColumnRequiredOne table block per question
    AnsweranswerColumnRequiredAnswer categories in model sort order (use Sort By Column)
    Columns (banner)bannerColumnOptionalOptional: segments shown as table columns with significance letters
    ValuevalueMeasureRequiredRespondent count — or Sum of Weight for weighted results
    Sum of Weight² (significance)weightsqMeasureOptionalOptional: SUM(weight²) enables effective bases for weighted significance
    Wave / PeriodwaveColumnOptionalOptional: tracker mode — the table shows the latest wave and the change since the previous one in every cell

    Themetheme

    SettingType and options
    ThemeselectedTheme
    • SmartVisuals smartvisuals
    • Dark dark
    • Clean (White) clean
    • Slate slate
    Transparent BackgroundtransparentBgOn / off
    Quick StylestylePreset
    • Custom (keep my settings) custom
    • Agency deck agency
    • Executive summary executive
    • Compact tracker compact

    Cellsdisplay

    SettingType and options
    Cell ContentcellContent
    • Column % pct
    • Value count
    • % and value both
    • Index vs Total index
    % Decimal PlacesdecimalsNumber
    Show Total ColumnshowTotalOn / off
    Show Base RowshowBaseRowOn / off
    Shade Cells by %heatmapOn / off
    Focus on Significant CellsfocusSignificantOn / off
    Transpose (segments as rows)transposeOn / off
    Show Search BoxshowSearchOn / off
    Show Change vs Previous WaveshowWaveDeltaOn / off
    Show Trend ColumnshowSparklineOn / off
    Show CSV ExportexportEnabledOn / off
    Mark Cells Above / Below TotaltestVsTotalOn / off

    Nets & Means (Premium)netSettings

    SettingType and options
    Top Box Net RowshowTopBoxOn / off
    Bottom Box Net RowshowBottomBoxOn / off
    Box Size (answer positions)boxSizeNumber
    Mean Row (answer position 1..k)showMeanRowOn / off
    Mean Decimal PlacesmeanDecimalsNumber

    LabelslabelSettings

    SettingType and options
    Font SizefontSizeNumber
    FontfontFamily
    • Inter inter
    • Segoe UI segoe
    • Arial arial
    • Georgia georgia
    Font ColorfontColorColour

    Significance (Premium)significance

    SettingType and options
    Column LettersenabledOn / off
    Confidence Levelconfidence
    • 90 % 90
    • 95 % 95
    • 99 % 99
    Min Base for TestingminBaseNumber
    Multiple-Comparison Correctioncorrection
    • None (agency convention) none
    • Bonferroni bonferroni
    Letter Color (empty = theme)letterColorColour
    Explain Letters in FootershowLetterLegendOn / off
    Hatch Low BaseslowBaseHatchOn / off

    Smart Captioninsights

    SettingType and options
    Show CaptionshowOn / off
    Positionposition
    • Top top
    • Bottom bottom

    Footnotefootnote

    SettingType and options
    Show FootnoteshowOn / off
    Template ({base} {n} {neff} {wave} {question} {source})templateText
    SourcesourceText

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