Pareto Chart fields and settings

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

    4 fields · 9 cards · 32 settings Markdown for AI assistantscatalog.json

    Fields

    FieldTakesNeededWhat it is for
    CategorycategoryColumnOptional · up to 4Categories ranked by contribution (defect codes, SKUs, root causes…). Add a hierarchy to drill.
    ValuevalueMeasureOptional · up to 4Contribution measure (count, cost, downtime…). Add more measures to switch metrics or draw a second cumulative line.
    Compare / Small multiplesgroupColumnOptionalOptional group field: 2 values = before/after comparison, more = small multiples.
    TooltipstooltipsMeasureOptional · up to 8Extra measures shown in tooltips.

    Themetheme

    SettingType and options
    ThemeselectedTheme
    • SmartVisuals smartvisuals
    • Dark dark
    • Clean (White) clean
    • Slate slate
    • Blueprint blueprint
    Transparent backgroundtransparentBgOn / off

    ChartchartSettings

    SettingType and options
    Vital few bar colorbarColorColour
    Trivial many bar colorbarColorAboveColour
    Cumulative line colorlineColorColour
    Pareto threshold %thresholdNumber
    Show threshold lineshowThresholdLineOn / off
    Max bars (rest grouped as Others)maxBarsNumber
    GridlinesshowGridOn / off

    Bar colorsdataPoint

    SettingType and options
    ColorfillColour

    LabelslabelSettings

    SettingType and options
    Font sizefontSizeNumber
    Font colorfontColorColour
    Show bar valuesshowValuesOn / off
    Show cumulative %showPctOn / off
    Show category labelsshowCategoryLabelsOn / off

    Smart insightsinsights

    SettingType and options
    Vital-few sentenceshowInsightsOn / off
    Headline calloutshowCalloutOn / off
    Mark threshold intersectionshowIntersectionOn / off

    ABC classificationabc

    SettingType and options
    Enable ABC zonesenabledOn / off
    A zone up to %boundaryANumber
    B zone up to %boundaryBNumber
    A colorcolorAColour
    B colorcolorBColour
    C colorcolorCColour
    Zone labelsshowZoneLabelsOn / off

    Data tableqmTable

    SettingType and options
    Show data tableshowOn / off
    Table font sizetableFontSizeNumber

    Measuresmeasures

    SettingType and options
    Active measureactiveMeasureText
    Second cumulative line (measure 2)secondLineOn / off
    Second line colorsecondLineColorColour

    Comparison & small multiplescomparison

    SettingType and options
    Mode with a group fieldmode
    • Auto (2 groups = compare) auto
    • Before / after comparison comparison
    • Small multiples multiples
    Show rank changesshowRankChangesOn / off

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