Formatting Reference

Column Significance Table

Complete guide to all formatting options available in the Chartura Column Significance Table Power BI custom visual, organised by section and group.

Grid

Global table behaviour that applies to the whole visual: cell borders, hover tooltips, and the number format used to render every data cell.

General

Show BordersToggle
Default: OnDraws a 1 px border around every cell in the table. Turn off for a cleaner, borderless grid.
TooltipsToggle
Default: OffWhen on, hovering a data cell shows a Power BI tooltip with the column, row, value, base size, and — when significance testing is enabled — the columns it is significantly higher / lower than along with each p-value.
Show Borders — On (Default) vs Off
Show Borders — On (Default)
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
Show Borders — Off
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%

Number Format

Decimal PointsNumber
Default: 0Number of decimal places shown in all data cells. Cells render as a percentage of the column base (count ÷ base).
PrefixText
Default: (EMPTY)Text prepended before each value (e.g. a currency symbol).
SuffixText
Default: %Text appended after each value (e.g. unit of measure).
Number Formats — Various Combinations
0 Decimal Points — % Suffix (Default)
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
1 Decimal Point — % Suffix
Gen ZAMillennialBGen XC
Aurora46.0%C38.7%33.4%
Aware of brand61.7%BC48.3%44.9%
Would consider43.6%C41.2%31.0%
Would purchase33.4%C28.9%24.3%
$ Prefix — No Suffix
Gen ZAMillennialBGen XC
Aurora$46C$39$33
Aware of brand$62BC$48$45
Would consider$44C$41$31
Would purchase$33C$29$24
No Prefix / No Suffix
Gen ZAMillennialBGen XC
Aurora46C3933
Aware of brand62BC4845
Would consider44C4131
Would purchase33C2924

Significance Testing

Compares each cell against the other columns in the same row using a statistical test of proportions. Each column is assigned a letter (A, B, C…) shown under its header, and a significant cell is marked with the letters of the columns it beats.

Test

EnableToggle
Default: OnMaster switch. When off, no significance markers are shown regardless of other settings.
TestDropdown
Default: Z-TestStatistical test method. Z-Test is better suited to percentages / proportions, while T-Test is better suited to means and smaller samples.
VarianceDropdown
Default: UnpooledHow the standard error is estimated. Unpooled (Wald — each column uses its own variance) or Pooled (equal-variance estimate, i.e. “assume equal variances”).
LevelDropdown
Default: 95%Confidence level for the test. Options: 90%, 95%, 99%. Higher confidence flags fewer cells.
Bonferroni CorrectionToggle
Default: OffAdjusts the confidence level for the number of pairwise comparisons in each row family, reducing false positives when many columns are compared.
Minimum Base SizeNumber
Default: 0Columns whose base (sample size) is below this value are excluded from testing. 0 disables the floor.
Test 0% / 100% CellsToggle
Default: OffOff suppresses cells at exactly 0% or 100% (zero variance), which is the statistically conservative default. On tests them anyway via the zero-variance branch.
Significance Testing — On vs Off
Enable — On, 95%, Z-Test (Default)
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
Enable — Off
Gen ZMillennialGen X
Aurora46%39%33%
Aware of brand62%48%45%
Would consider44%41%31%
Would purchase33%29%24%

Display

ShowDropdown
Default: Higher onlyWhich results to display. Options: Higher only (each cell lists the columns it beats), Higher & Lower, Lower only. The test is always two-tailed; this only filters what is shown.
Display StyleDropdown
Default: LettersHow a significant result is rendered. Options: Letters, Arrows, Dot, Letter Pill. For Arrows and Dot with Show set to Higher & Lower, a cell that is significant in both directions uses a single marker whose color is a blend of the Higher and Lower colors, weighted by how many columns it beats vs loses to — e.g. significantly higher than 4 columns and lower than 1 gives 80% Higher color + 20% Lower color.
Show — Higher only (Default) vs Higher & Lower
Higher only (Default)
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
Higher & Lower
Gen ZAMillennialBGen XC
Aurora46%C39%33%A
Aware of brand62%BC48%A45%A
Would consider44%C41%31%AB
Would purchase33%C29%24%A
Display Style — All Options
Letters (Default)
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
Arrows
Gen ZAMillennialBGen XC
Aurora46%39%33%
Aware of brand62%48%45%
Would consider44%41%31%
Would purchase33%29%24%
Dot
Gen ZAMillennialBGen XC
Aurora46%39%33%
Aware of brand62%48%45%
Would consider44%41%31%
Would purchase33%29%24%
Letter Pill
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%

Higher Results

Foreground ColorColor
Default: #AEE000Color of the letters, arrows, dots, and pill text for cells that are significantly higher.
Foreground Opacity (%)Slider
Default: 100%
Background ColorColor
Default: #AEE000Cell background fill used for higher cells by the Letter Pill style and the hover highlight styles.
Background Opacity (%)Slider
Default: 20%
Higher Results — Default vs Customized Color
Default — #AEE000
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
Customized — Dark Blue Letters
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%

Lower Results

Foreground ColorColor
Default: #F14950Color of the letters, arrows, dots, and pill text for cells that are significantly lower.
Foreground Opacity (%)Slider
Default: 100%
Background ColorColor
Default: #F14950Cell background fill used for lower cells by the Letter Pill style and the hover highlight styles.
Background Opacity (%)Slider
Default: 20%
Lower Results — Letter Pill style (foreground + background)
Default — #F14950
Gen ZAMillennialBGen XC
Aurora46%C39%33%A
Aware of brand62%BC48%A45%A
Would consider44%C41%31%AB
Would purchase33%C29%24%A
Customized — Orange
Gen ZAMillennialBGen XC
Aurora46%C39%33%A
Aware of brand62%BC48%A45%A
Would consider44%C41%31%AB
Would purchase33%C29%24%A

Highlighting

Hover Display StyleDropdown
Default: Cell FillHow peer cells are highlighted when hovering a cell. Options: None, Cell Fill, Bordered Cell Fill, Underline, Side Rail. Uses the Higher / Lower background & foreground colors.
Border WidthNumber
Default: 2 pxThickness used by the Bordered Cell Fill, Underline, and Side Rail hover styles. Range 1–10 px.
Highlight Peers asDropdown
Default: Peer’s resultWhether highlighted peers are colored by the peer’s own result or by the active (hovered) cell’s result.
Highlight Row CellsToggle
Default: OnWhen on, hovering a cell highlights its significant peers across the same row.
Highlight Column HeadersToggle
Default: OnWhen on, hovering a cell also highlights the headers of the columns it is being compared against.
Hover Display Style — How a highlighted peer cell looks
Cell Fill (Default)
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%A45%
Would consider44%C41%31%
Would purchase33%C29%24%
Bordered Cell Fill
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%A45%
Would consider44%C41%31%
Would purchase33%C29%24%
Underline
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%A45%
Would consider44%C41%31%
Would purchase33%C29%24%
Side Rail
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%A45%
Would consider44%C41%31%
Would purchase33%C29%24%

Active Cell

EnableToggle
Default: OnWhen on, the cell currently under the cursor is filled with the active-cell color while its peers are highlighted.
Background ColorColor
Default: #A0A7D8Background fill of the active (hovered) cell.
Background Opacity (%)Slider
Default: 35%
Font ColorColor
Default: #000000Text color of the active cell while hovered.
Active Cell — “Aware of brand” / Gen Z hovered
Enable — On (Default)
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%A45%A
Would consider44%C41%31%
Would purchase33%C29%24%
Enable — Off (peers still highlighted)
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%A45%A
Would consider44%C41%31%
Would purchase33%C29%24%

Column Headers

The top header row that labels each column and shows its stat-test letter. Controls header text styling, background, sticky behaviour, and the drill-down controls for the column hierarchy.

Text

AlignmentAlignment
Default: CenterHorizontal text alignment of the column header labels. Options: Left, Center, Right.
FontFont
Default: Calibri, 14 pxFont family, size, and bold / italic / underline for header labels.
Font ColorColor
Default: #000000Text color of the column header labels.
Column Headers Text — Default vs Customized
Default
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
Bold, 15 px, Dark Blue
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%

Background

BackgroundColor
Default: #F0F0F0Background color of the column header row.
Opacity (%)Slider
Default: 100%Opacity of the header background fill.
Column Header Background — Default vs Customized
Default — #F0F0F0
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
Customized — Dark Blue / White Text
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%

Behavior

StickyToggle
Default: OnPins the column header row to the top of the viewport so it stays visible while scrolling large tables.
Drill Down ControlsToggle
Default: OnShows the drill-up / drill-down icon buttons. They render in the row-header gutter but drive expand / collapse on the column hierarchy.
Icon ColorColor
Default: #252423Fill color of active (enabled) drill control icons.
Disabled ColorColor
Default: #c8c6c4Fill color of drill icons when that action is unavailable (no further drill level).
Hover ColorColor
Default: #12239EFill color of drill icons on mouse hover.
Drill Down Controls — On vs Off
Drill Down Controls — On (Default)
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
Drill Down Controls — Off
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
Drill Icon Colors — Default vs Customized
Default (Icon / Disabled)
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
Customized — Dark Blue Icon / Disabled
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%

Row Headers

The leftmost column that labels each row. Controls its text styling, width, and background.

Text

AlignmentAlignment
Default: LeftHorizontal text alignment of the row labels. Options: Left, Center, Right. Affects how nested (drilled-down) rows are indented.
FontFont
Default: Calibri, 14 pxFont family, size, and bold / italic / underline for row labels.
Font ColorColor
Default: #000000Text color of the row labels.
Row Headers Text — Default vs Customized
Default
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
Bold, 15 px, Dark Blue
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%

Background

Width (px)Number
Default: 300Fixed width of the row-header column. Range 0–600 px. Useful for keeping long labels on one line.
BackgroundColor
Default: #ffffffBackground color of the row-header column.
Opacity (%)Slider
Default: 100%Opacity of the row-header background fill.
Row Header Background — Default vs Customized
Default — #ffffff
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
Customized — Light Grey
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%

Values

The data cells themselves. Controls value text styling, the base cell background, alternating row / column banding, row / column hover highlighting, and cross-filtering selection colors.

Text

AlignmentAlignment
Default: CenterHorizontal alignment of the value text within each cell.
FontFont
Default: Calibri, 14 pxFont family, size, and bold / italic / underline for data values.
Font ColorColor
Default: #000000Text color of the data values (significance markers keep their own Higher / Lower colors).
Values Text — Default vs Customized
Default
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
Bold, 15 px, Dark Blue
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%

Background

Row BackgroundColor
Default: #ffffffBase background color applied to every data cell.
Row Opacity (%)Slider
Default: 50%Opacity of the base cell background fill.
Values Background — Default vs Customized
Default — White @ 50%
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
Customized — Pale Blue
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%

Row Banding

EnableToggle
Default: OffShades alternate rows for easier left-to-right reading.
Font ColorColor
Default: #000000Text color applied to banded rows.
Row BackgroundColor
Default: #ffffffBackground color of the banded (alternate) rows.
Row Opacity (%)Slider
Default: 70%
Row Banding — Off vs On
Row Banding — Off (Default)
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
Row Banding — On
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%

Column Banding

EnableToggle
Default: OffShades alternate columns for easier top-to-bottom reading.
Font ColorColor
Default: #000000Text color applied to banded columns.
BackgroundColor
Default: #ffffffBackground color of the banded (alternate) columns.
Opacity (%)Slider
Default: 70%
Column Banding — Off vs On
Column Banding — Off (Default)
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
Column Banding — On (Millennial shaded)
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%

Row Hover

EnableToggle
Default: OnHighlights the entire row under the cursor.
Font ColorColor
Default: #000000Text color of the hovered row.
Row BackgroundColor
Default: #A0A7D8Background color of the hovered row.
Row Opacity (%)Slider
Default: 10%
Row Hover — “Would consider” row hovered
Row Hover — On (Default)
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
Row Hover — Off
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%

Column Hover

EnableToggle
Default: OnHighlights the entire column under the cursor.
Font ColorColor
Default: #000000Text color of the hovered column.
Column BackgroundColor
Default: #A0A7D8Background color of the hovered column.
Column Opacity (%)Slider
Default: 10%
Column Hover — column A (Gen Z) hovered
Column Hover — On (Default)
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
Column Hover — Off
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%

Cross-Filtering

Background ColorColor
Default: #E5E5E5Background color of a cell that is selected to cross-filter the rest of the report.
Font ColorColor
Default: #212121Text color of a selected (cross-filtering) cell.
Hover Background ColorColor
Default: #CFCFCFBackground color shown when hovering a selectable cell before clicking.
Hover Font ColorColor
Default: #111111Text color shown when hovering a selectable cell before clicking.
Cross-Filtering — “Aware of brand” / Gen Z selected
Selected cell — cross-filtering the report
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
No selection (Default)
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%

Subtotals & Totals

Styling for the aggregate rows and columns: row subtotals (from drilled-down hierarchies), column subtotals, and the grand-total column. Each can optionally override the default value styling.

Row Subtotals

Custom StyleToggle
Default: OnWhen on, row subtotal rows (the collapsible parent / group rows, like the brand row below) use the styling below; when off, they inherit the normal value styling.
AlignmentAlignment
Default: Center
FontFont
Default: Calibri, 14 pxFont family, size, and bold / italic / underline.
Font ColorColor
Default: #000000Text color of subtotal rows.
BackgroundColor
Default: #f0f0f0Background color of subtotal rows.
Opacity (%)Slider
Default: 0%
Row Subtotals — the brand row is the subtotal of its funnel
Default
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
Bold, Dark Blue, Shaded
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%

Column Subtotals

Custom StyleToggle
Default: OnWhen on, column subtotal cells use the styling below; when off, they inherit the normal value styling.
AlignmentAlignment
Default: Center
FontFont
Default: Calibri, 14 pxFont family, size, and bold / italic / underline.
Font ColorColor
Default: #000000Text color of column subtotal cells.
BackgroundColor
Default: #f0f0f0Background color of column subtotal cells.
Opacity (%)Slider
Default: 0%
Column Subtotals — Aurora (A) drilled into Classic (A1) and Max (A2), with the Aurora subtotal column (A)
Default
ClassicA1MaxA2AuroraA
Aware of brand62%A248%55%
Would consider44%41%43%
Would purchase33%29%31%
Bold, Dark Blue Subtotal Column
ClassicA1MaxA2AuroraA
Aware of brand62%A248%55%
Would consider44%41%43%
Would purchase33%29%31%

Table Total

Show Table TotalToggle
Default: OffMaster switch for the rightmost grand-total column. When off, the total column is hidden entirely.
Custom StyleToggle
Default: OnWhen on, the total column uses the styling below; when off, it inherits the normal value styling.
AlignmentAlignment
Default: Center
FontFont
Default: Calibri, 14 pxFont family, size, and bold / italic / underline.
Font ColorColor
Default: #000000Text color of the grand-total column.
BackgroundColor
Default: #f0f0f0Background color of the grand-total column.
Opacity (%)Slider
Default: 0%
Show Table Total — Off (Default) vs On
Show Table Total — Off (Default)
Gen ZAMillennialBGen XC
Aurora46%C39%33%
Aware of brand62%BC48%45%
Would consider44%C41%31%
Would purchase33%C29%24%
Show Table Total — On
Gen ZAMillennialBGen XCTotal
Aurora46%C39%33%40%
Aware of brand62%BC48%45%52%
Would consider44%C41%31%39%
Would purchase33%C29%24%29%

Appendix — Emulating WinCross / SPSS

To reproduce the column-significance behaviour of WinCross or SPSS, set the Significance Testing options as follows.

Quick reference

SettingWinCrossSPSS
EnableOnOn
TestZ-TestZ-Test
VarianceUnpooledPooled
Level95%95%
Bonferroni CorrectionOffOn ‡
Test 0% / 100% CellsOff (suppress)Off (suppress)
Minimum Base Size0 †0 †
Display StyleLettersLetters
ShowHigher onlyHigher only

† Leave Minimum Base Size at 0 unless you want to suppress columns below a reporting threshold.

‡ SPSS applies a Bonferroni adjustment to pairwise column comparisons by default; enable it to match.

These settings align the visual’s test configuration with WinCross / SPSS defaults; however, results may diverge in edge cases owing to differences in floating-point rounding, variance and standard-error estimation, effective (weighted) base handling, and small-sample or continuity corrections.