Venn & UpSet fields and settings

    Every field well and every setting in the format pane of version 1.1.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 Venn & UpSet page; every setting works in edit mode with or without one.

    8 fields · 18 cards · 255 settings Markdown for AI assistantscatalog.json

    Fields

    FieldTakesNeededWhat it is for
    ID (respondent, customer…)entityColumnOptionalOne value per person or thing whose memberships you count: respondent ID, customer ID, user ID. Counts are distinct IDs.
    Sets (answer, item)setColumnOptionalLong data: the answer or item on each row (one row per selection). A cell like "A;B;C" is split automatically.
    Set flags (one per set)flagsMeasureOptional · up to 30Wide data: one field per set; 1, TRUE, Yes or any non-blank text means member. Use First/Max for text columns.
    Count (pre-aggregated)countMeasureOptionalPre-aggregated data: how many IDs each row stands for. Use with a combination in Sets (e.g. "A;B").
    WeightweightMeasureOptionalSurvey weight per ID (use Max or Average of the weight column). Premium: weighted counts and effective base.
    ValuevalueMeasureOptionalA value per ID, e.g. revenue. Premium: size and label overlaps by value.
    Compare bygroupColumnOptionalWave, segment or period. Premium: small multiples and significance letters across groups.
    TooltipstooltipsMeasureOptional · up to 5Extra measures shown per combination in tooltips (sum or average).

    Viewview

    SettingType and options
    Chartmode
    • Auto (Venn for few sets, UpSet for more) auto
    • Venn / Euler venn
    • UpSet upset
    • Duplication matrix matrix
    • TURF reach turf
    Intersectionscounts
    • Exclusive (exactly these sets) exclusive
    • Inclusive (at least these sets) inclusive
    Showshow
    • Count and % of base both
    • Count count
    • % of base percent
    Size bysizeBy
    • Count count
    • Value field value
    Show "none of these"showNoneOn / off

    Venn / Eulervenn

    SettingType and options
    Layoutlayout
    • Area-proportional (Euler) proportional
    • Classic (not to scale) classic
    Shapesshape
    • Auto (ellipses when circles cannot fit) auto
    • Circles circles
    • Ellipses (best fit) ellipses
    Venn up tomaxSets
    • 3 sets 3
    • 4 sets (not to scale) 4
    • 5 sets (not to scale) 5
    Stylestyle
    • From theme auto
    • Soft soft
    • Solid solid
    • Outline outline
    • Glow glow
    Region labelsregionLabels
    • Auto auto
    • Count count
    • % of base percent
    • Count and % both
    • Off none
    Set labelssetLabels
    • Name and % nameShare
    • Name and count nameCount
    • Name name
    • Off none
    Fill opacity %fillOpacityNumber
    Outline widthstrokeWidthNumber
    Fit badgeshowFitBadgeOn / off
    Focus region on hoverhoverFocusOn / off
    Animate changesanimateOn / off

    UpSetupset

    SettingType and options
    Sort intersectionssort
    • By size size
    • By degree, then size degree
    • Widest first degreeDesc
    • By set order sets
    Set ordersetOrder
    • By size size
    • As in data data
    • By name name
    Max intersectionsmaxIntersectionsNumber
    Min sizeminSizeNumber
    Min degreeminDegreeNumber
    Max degreemaxDegreeNumber
    Hide emptyhideEmptyOn / off
    Set-size barsshowSetBarsOn / off
    Value labelsshowValuesOn / off
    Bar scalescale
    • Linear linear
    • Logarithmic log
    GridlinesshowGridOn / off
    Bar colorbarColorColour
    Member dot colordotColorColour
    Non-member dot coloremptyDotColorColour
    Dot sizedotSizeNumber
    Connector colorconnectorColorColour
    "None" bar colornoneColorColour
    Gridline colorgridColorColour
    Axis labelsshowAxisOn / off
    Axis label coloraxisColorColour
    Interval whisker colorwhiskerColorColour

    Legendlegend

    SettingType and options
    LegendshowOn / off
    Positionposition
    • Top top
    • Bottom bottom
    • Right right
    • Left left
    TitleshowTitleOn / off
    Title text (blank = the Sets field name)titleText
    Valuesvalues
    • None none
    • % of base share
    • Count count
    Font sizefontSizeNumber
    Text colorcolorColour

    Reference linerefLine

    SettingType and options
    Reference lineshowOn / off
    Valuetype
    • Average of shown combinations average
    • Median of shown combinations median
    • Constant constant
    Constant (count, or % when bars show shares)valueNumber
    Line stylestyle
    • Dashed dashed
    • Dotted dotted
    • Solid solid
    Line colorcolorColour
    LabelshowLabelOn / off

    Annotationsannotations

    SettingType and options
    AnnotationsshowOn / off
    Note 1: sets (joined by &)target1Text
    Note 1: texttext1Text
    Note 2: sets (joined by &)target2Text
    Note 2: texttext2Text
    Note 3: sets (joined by &)target3Text
    Note 3: texttext3Text
    Note colorcolorColour

    Set colorssets

    SettingType and options
    Colors by rule (fx)fxColour
    color 1color0Colour
    color 2color1Colour
    color 3color2Colour
    color 4color3Colour
    color 5color4Colour
    color 6color5Colour
    color 7color6Colour
    color 8color7Colour
    color 9color8Colour
    color 10color9Colour
    color 11color10Colour
    color 12color11Colour
    color 13color12Colour
    color 14color13Colour
    color 15color14Colour
    color 16color15Colour
    color 17color16Colour
    color 18color17Colour
    color 19color18Colour
    color 20color19Colour
    color 21color20Colour
    color 22color21Colour
    color 23color22Colour
    color 24color23Colour
    color 25color24Colour
    color 26color25Colour
    color 27color26Colour
    color 28color27Colour
    color 29color28Colour
    color 30color29Colour
    NamesnamesText

    Sets shownsetFilter

    SettingType and options
    Max sets (largest first)maxSetsNumber
    show 1show0On / off
    show 2show1On / off
    show 3show2On / off
    show 4show3On / off
    show 5show4On / off
    show 6show5On / off
    show 7show6On / off
    show 8show7On / off
    show 9show8On / off
    show 10show9On / off
    show 11show10On / off
    show 12show11On / off
    show 13show12On / off
    show 14show13On / off
    show 15show14On / off
    show 16show15On / off
    show 17show16On / off
    show 18show17On / off
    show 19show18On / off
    show 20show19On / off
    show 21show20On / off
    show 22show21On / off
    show 23show22On / off
    show 24show23On / off
    show 25show24On / off
    show 26show25On / off
    show 27show26On / off
    show 28show27On / off
    show 29show28On / off
    show 30show29On / off

    Set queryquery

    SettingType and options
    QueryenabledOn / off
    Matchmode
    • Any of any
    • All of all
    • Exactly exactly
    • None of none
    Highlight colorcolorColour
    include 1include0On / off
    include 2include1On / off
    include 3include2On / off
    include 4include3On / off
    include 5include4On / off
    include 6include5On / off
    include 7include6On / off
    include 8include7On / off
    include 9include8On / off
    include 10include9On / off
    include 11include10On / off
    include 12include11On / off
    include 13include12On / off
    include 14include13On / off
    include 15include14On / off
    include 16include15On / off
    include 17include16On / off
    include 18include17On / off
    include 19include18On / off
    include 20include19On / off
    include 21include20On / off
    include 22include21On / off
    include 23include22On / off
    include 24include23On / off
    include 25include24On / off
    include 26include25On / off
    include 27include26On / off
    include 28include27On / off
    include 29include28On / off
    include 30include29On / off

    Datadata

    SettingType and options
    Split answers ondelimiter
    • Auto (; or |) auto
    • Semicolon ; semicolon
    • Comma , comma
    • Pipe | pipe
    • Do not split none
    "None" answersnoneAnswersText
    Value per IDvaluePerId
    • Sum of rows sum
    • Largest row (ID attribute) max
    Tooltip measurestooltipAgg
    • Sum per combination sum
    • Average per combination average

    Overlap intelligencestats

    SettingType and options
    Apply weightsuseWeightsOn / off
    Effective baseshowEffectiveBaseOn / off
    Confidence intervalsshowCIOn / off
    Confidence levelconfidence
    • 95% 95
    • 90% 90
    • 99% 99
    Interval methodciMethod
    • Wilson score wilson
    • Wald (normal) wald
    Deviation from independenceshowDeviationOn / off
    Min base for testsminBaseNumber
    Bonferroni correctionbonferroniOn / off
    Above expectation coloroverColorColour
    Below expectation colorunderColorColour

    Compare groupscompare

    SettingType and options
    Layoutlayout
    • Auto auto
    • Small multiples multiples
    • Grouped bars (UpSet) grouped
    Significance lettersshowLettersOn / off
    Max panelsmaxPanelsNumber
    groupColor 1groupColor0Colour
    groupColor 2groupColor1Colour
    groupColor 3groupColor2Colour
    groupColor 4groupColor3Colour
    groupColor 5groupColor4Colour
    groupColor 6groupColor5Colour
    groupColor 7groupColor6Colour
    groupColor 8groupColor7Colour
    groupColor 9groupColor8Colour
    groupColor 10groupColor9Colour
    groupColor 11groupColor10Colour
    groupColor 12groupColor11Colour
    groupColor 13groupColor12Colour
    groupColor 14groupColor13Colour
    groupColor 15groupColor14Colour
    groupColor 16groupColor15Colour
    groupColor 17groupColor16Colour
    groupColor 18groupColor17Colour
    groupColor 19groupColor18Colour
    groupColor 20groupColor19Colour
    groupColor 21groupColor20Colour
    groupColor 22groupColor21Colour
    groupColor 23groupColor22Colour
    groupColor 24groupColor23Colour
    groupColor 25groupColor24Colour
    groupColor 26groupColor25Colour
    groupColor 27groupColor26Colour
    groupColor 28groupColor27Colour
    groupColor 29groupColor28Colour
    groupColor 30groupColor29Colour
    Group namesgroupNamesText

    TURFturf

    SettingType and options
    Portfolio sizes up tomaxKNumber
    forced 1forced0On / off
    forced 2forced1On / off
    forced 3forced2On / off
    forced 4forced3On / off
    forced 5forced4On / off
    forced 6forced5On / off
    forced 7forced6On / off
    forced 8forced7On / off
    forced 9forced8On / off
    forced 10forced9On / off
    forced 11forced10On / off
    forced 12forced11On / off
    forced 13forced12On / off
    forced 14forced13On / off
    forced 15forced14On / off
    forced 16forced15On / off
    forced 17forced16On / off
    forced 18forced17On / off
    forced 19forced18On / off
    forced 20forced19On / off
    forced 21forced20On / off
    forced 22forced21On / off
    forced 23forced22On / off
    forced 24forced23On / off
    forced 25forced24On / off
    forced 26forced25On / off
    forced 27forced26On / off
    forced 28forced27On / off
    forced 29forced28On / off
    forced 30forced29On / off

    Duplication matrixmatrix

    SettingType and options
    Cells showcell
    • % of row set also in column set alsoPct
    • Lift lift
    • Overlap (Jaccard) jaccard
    Significance marksshowSigOn / off
    Cell colorcolorColour

    Labelslabels

    SettingType and options
    Fontfont
    • Inter inter
    • Segoe UI segoe
    • Arial arial
    • Georgia georgia
    Font sizefontSizeNumber
    Font colorcolorColour
    % decimalspercentDecimalsNumber

    Notesnotes

    SettingType and options
    Base noteshowBaseOn / off
    Base labelbaseLabelText
    Fit noteshowFitNoteOn / off
    Data warningsshowWarningsOn / off
    Titles and captionsshowCaptionsOn / off
    Notes colorcolorColour
    Notes font sizefontSizeNumber
    Badge and chip colorbadgeColorColour
    Badge and chip text colorbadgeTextColorColour

    Themetheme

    SettingType and options
    ThemeselectedTheme
    • SmartVisuals smartvisuals
    • Dark dark
    • Clean (White) clean
    • Slate slate
    Transparent backgroundtransparentBgOn / off
    Use report theme colorsuseReportThemeOn / off

    Accessibilityaccessibility

    SettingType and options
    Focus outline colorfocusColorColour
    Focus outline widthfocusWidthNumber
    Minimum text size (0 = off)minFontSizeNumber

    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": "upsetVennE30F1ED6F31446988B04E836AFF14BEF",
      "objects": {
        "view": [{
          "properties": {
            "showNone": { "expr": { "Literal": { "Value": "true" } } }
          }
        }]
      }
    }