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

12 fields · 19 cards · 103 settings Markdown for AI assistants catalog.json

Fields

Field	Takes	Needed	What it is for
Group`group`	Column	Optional	One distribution per group along the axis
Split By`series`	Column	Optional	Side-by-side distributions within each group; two levels make a split violin
Sample / ID`detail`	Column	Optional	The observation grain, e.g. Measurement ID - without it Power BI sums the values
Value`value`	Measure	Optional	The observed value per Sample / ID
Value (as column)`valueColumn`	Column	Optional	For large data: the value itself as a column, with Count as the measure
Count`count`	Measure	Optional	How many observations have this value (with Value as column)
Weight`weight`	Measure	Optional	Survey or sampling weight per observation (premium)
Small Multiples`facet`	Column	Optional	One panel per value, shared axis (premium)
Tooltips`tooltips`	Measure	Optional	Extra fields in point tooltips
Lower Spec Limit (LSL)`lsl`	Measure	Optional	Lower spec limit per group, e.g. from a spec table (premium); replaces the typed LSL
Upper Spec Limit (USL)`usl`	Measure	Optional	Upper spec limit per group, e.g. from a spec table (premium); replaces the typed USL
Spec Target`target`	Measure	Optional	Target per group for Cpm and the target line (premium); replaces the typed target

Layout`layout`

Setting	Type and options
Orientation`orientation`	Vertical `vertical` Horizontal `horizontal`
Sort Groups By`sortGroups`	Data order `data` Name `name` Median `median` Mean `mean` Number of observations `n` Spread (IQR) `iqr`
Sort Direction`sortDirection`	Ascending `asc` Descending `desc`
Hide Groups With Fewer Than`minGroupSize`	Number
Space Between Groups (%)`groupGap`	Number

Statistics`stats`

Setting Type and options

Setting	Type and options
Quartile Method`quartileMethod`	Excel / DAX inclusive: PERCENTILE.INC (type 7) `linear` Excel / DAX exclusive: PERCENTILE.EXC, Minitab, SPSS (type 6) `weibull` Tukey's hinges (R fivenum) `tukey` Median-unbiased (type 8) `median_unbiased` Midpoint, Hazen (type 5) `hazen` Normal-unbiased (type 9) `normal_unbiased` Linear CDF (type 4) `interpolated_inverted_cdf` Nearest rank, inverted CDF (type 1) `inverted_cdf` Averaged inverted CDF (type 2) `averaged_inverted_cdf` Closest observation (type 3) `closest_observation`

Quartile MethodquartileMethod

Excel / DAX inclusive: PERCENTILE.INC (type 7) linear
Excel / DAX exclusive: PERCENTILE.EXC, Minitab, SPSS (type 6) weibull
Tukey's hinges (R fivenum) tukey
Median-unbiased (type 8) median_unbiased
Midpoint, Hazen (type 5) hazen
Normal-unbiased (type 9) normal_unbiased
Linear CDF (type 4) interpolated_inverted_cdf
Nearest rank, inverted CDF (type 1) inverted_cdf
Averaged inverted CDF (type 2) averaged_inverted_cdf
Closest observation (type 3) closest_observation

Density`density`

Setting	Type and options
Bandwidth Rule`bandwidthRule`	Scott `scott` Silverman `silverman` Silverman rule of thumb (R default) `nrd0`
Smoothness (%)`smoothness`	Number
Trim to Data Range`trim`	On / off
Violin Width`scale`	Equal area `area` Equal width `width` By number of observations `count`
Inside the Violin`inner`	Box `box` Quartile lines `quartiles` Points `points` Nothing `none`
Show Rain (Points)`rain`	On / off
Ridge Overlap (%)`overlap`	Number
Fill Opacity (%, -1 = theme)`fillOpacity`	Number

Bins`bins`

Setting	Type and options
Binning`rule`	Freedman-Diaconis `fd` Sturges `sturges` Scott `scott` Rice `rice` Square root `sqrt` Doane `doane` Auto (numpy) `auto` Fixed number of bins `count` Fixed bin width `width` Custom bin edges `custom`
Round Bin Edges`nice`	On / off
Number of Bins`count`	Number
Bin Width`width`	Number
Bin Edges`edges`	Text
Set Bin Start`useAnchor`	On / off
A Bin Starts At`anchor`	Number
Bar Height`measure`	Count `count` Percent of group `percent` Density `density`
Groups`groupMode`	Auto (overlaid up to two, else rows) `auto` Overlaid `overlay` Stacked `stacked` One row per group `rows`
Gap Between Bars (px)`gap`	Number
Cumulative % Line`showCumulative`	On / off
Density Curve`showDensity`	On / off
Fitted Normal Curve`showNormal`	On / off
Bar Height Axis Title`showHeightTitle`	On / off

Compare Groups`compare`

Setting	Type and options
Test Differences`show`	On / off
Test`test`	Welch t-test (means) `welch` Mann-Whitney U (ranks) `mannwhitney`
Overall Test`omnibus`	Welch's ANOVA `welchAnova` One-way ANOVA `anova` Kruskal-Wallis `kruskal`
Multiple Comparisons`correction`	Holm `holm` Bonferroni `bonferroni` None `none`
Confidence`level`	90 % `90` 95 % `95` 99 % `99`
Show As`display`	Brackets with stars `brackets` Letters (A, B, C) `letters`
Pairs`pairs`	All pairs `all` Each vs the first group `first` Neighbours only `adjacent`
Show Non-significant Pairs`showNs`	On / off

Spec Limits & Capability`spec`

Setting	Type and options
Lower Spec Limit`useLsl`	On / off
LSL`lsl`	Number
Upper Spec Limit`useUsl`	On / off
USL`usl`	Number
Target`useTarget`	On / off
Target Value`target`	Number
Show Cp, Cpk, Cpl, Cpu, Cpm, Pp, Ppk`showIndices`	On / off
Control Limits (±3σ within)`showControl`	On / off
Limit Color`color`	Colour

Advanced Density`kde`

Setting	Type and options
Kernel`kernel`	Gaussian `gaussian` Epanechnikov `epanechnikov` Biweight `biweight` Triangular `triangular` Cosine `cosine` Uniform (box) `uniform`
Fixed Bandwidth (0 = rule)`fixedBandwidth`	Number
Bounded Below`useLower`	On / off
Lower Bound`lower`	Number
Bounded Above`useUpper`	On / off
Upper Bound`upper`	Number

Statistic Lines`statLines`

Setting	Type and options
Mean Line`showMean`	On / off
Median Line`showMedian`	On / off
Percentile Lines`percentiles`	Text
Computed For`scope`	All data in the panel `all` Each group `group`
Labels`showLabels`	On / off
Color`color`	Colour

Reference Line`reference`

Setting	Type and options
Show Reference Line`show`	On / off
Value`value`	Number
Label`label`	Text
Color`color`	Colour

Value Axis`valueAxis`

Setting	Type and options
Show`show`	On / off
Fixed Minimum`useMin`	On / off
Minimum`min`	Number
Fixed Maximum`useMax`	On / off
Maximum`max`	Number
Logarithmic Scale`log`	On / off
Gridlines`gridlines`	On / off
Show Title`showTitle`	On / off
Title`title`	Text
Decimal Places (-1 = auto)`decimals`	Number
Font Size`fontSize`	Number
Text Color`color`	Colour

Group Axis`categoryAxis`

Setting	Type and options
Show`show`	On / off
Show n per Group`showN`	On / off
Font Size`fontSize`	Number
Text Color`color`	Colour
Show Title`showTitle`	On / off

Data Labels`labels`

Setting	Type and options
Median`showMedian`	On / off
Quartiles`showQuartiles`	On / off
Mean`showMean`	On / off
Font Size`fontSize`	Number

Data Labels`histLabels`

Setting	Type and options
Bar Values`show`	On / off
Font Size`fontSize`	Number

Colors`colors`

Setting	Type and options
One Colour for All Groups`single`	On / off
Colour`fill`	Colour

Legend`legend`

Setting	Type and options
Show`show`	On / off
Position`position`	Top `top` Bottom `bottom`
Font Size`fontSize`	Number
Text Color`color`	Colour

Smart Caption`caption`

Setting	Type and options
Show`show`	On / off
Position`position`	Top `top` Bottom `bottom`
Font Size`fontSize`	Number
Text Color`color`	Colour

Footnote`footnote`

Setting	Type and options
Show`show`	On / off
Source`source`	Text
State the Methods`showMethod`	On / off
Font Size`fontSize`	Number
Text Color`color`	Colour

Theme`theme`

Setting	Type and options
Theme`selectedTheme`	SmartVisuals `smartvisuals` Dark `dark` Clean (White) `clean` Slate `slate`
Font`font`	Inter `inter` Segoe UI `segoe` Arial `arial` Georgia `georgia`
Transparent Background`transparentBg`	On / off

Group Colors`groupColors`

Setting	Type and options
Colour`fill`	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": "smartvisualsHistogram0B2CDFBFD376F32FDEA400260852BF18",
  "objects": {
    "density": [{
      "properties": {
        "trim": { "expr": { "Literal": { "Value": "true" } } }
      }
    }]
  }
}

Histogram fields and settings

Fields

Layoutlayout

Statisticsstats

Densitydensity

Binsbins

Compare Groupscompare

Spec Limits & Capabilityspec

Advanced Densitykde

Statistic LinesstatLines

Reference Linereference

Value AxisvalueAxis

Group AxiscategoryAxis

Data Labelslabels

Data LabelshistLabels

Colorscolors

Legendlegend

Smart Captioncaption

Footnotefootnote

Themetheme

Group ColorsgroupColors