Formatting Reference

Wave Significance Table

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

Table

General table behaviour: drill-down controls, cell borders, sticky header/footer, number formatting applied to all data cells.

General

Drill Down ControlsToggle
Default: OnShows or hides the drill-up, drill-all-down, and drill-one-down icon buttons in the column header area.
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.
Show BordersToggle
Default: OffAdds a 1 px border around every cell in the table.
Table TotalToggle
Default: OnShows or hides the rightmost grand-total column.
Drill Down Controls — On vs Off
Drill Down Controls — On (Default)
20242025Total
Brand A24%25%▲24%
Brand B19%23%▲21%
Brand C28%27%▼27%
Brand D30%27%▼28%
Total25%25%25%
Drill Down Controls — Off
20242025Total
Brand A24%25%▲24%
Brand B19%23%▲21%
Brand C28%27%▼27%
Brand D30%27%▼28%
Total25%25%25%
Drill Down Icon Colors — Default vs Customized
Default Icon Colors (Icon / Disabled / Hover)
20242025Total
Brand A24%25%▲24%
Brand B19%23%▲21%
Brand C28%27%▼27%
Brand D30%27%▼28%
Total25%25%25%
Customized Icon Colors (Icon / Disabled / Hover)
20242025Total
Brand A24%25%▲24%
Brand B19%23%▲21%
Brand C28%27%▼27%
Brand D30%27%▼28%
Total25%25%25%
Show Borders — Off vs On
Show Borders — Off (Default)
20242025Total
Brand A24%25%▲24%
Brand B19%23%▲21%
Brand C28%27%▼27%
Brand D30%27%▼28%
Total25%25%25%
Show Borders — On
20242025Total
Brand A24%25%▲24%
Brand B19%23%▲21%
Brand C28%27%▼27%
Brand D30%27%▼28%
Total25%25%25%
Table Total — On vs Off
Table Total — On (Default)
20242025Total
Brand A24%25%▲24%
Brand B19%23%▲21%
Brand C28%27%▼27%
Brand D30%27%▼28%
Total25%25%25%
Table Total — Off
20242025
Brand A24%25%▲
Brand B19%23%▲
Brand C28%27%▼
Brand D30%27%▼
Total25%25%

Header

StickyToggle
Default: OnPins the column header row to the top of the viewport so it remains visible when scrolling through large datasets.
Sticky Header — header stays visible while scrolling
Sticky Headers — On (Default)
20242025Total
Brand A24%25%▲24%
Product A128%30%29%
Product A219%20%19%
Brand B19%23%▲21%
Product B123%28%▲26%
Total25%25%25%
Sticky Headers — Off
20242025Total
Brand A24%25%▲24%
Product A128%30%29%
Product A219%20%19%
Brand B19%23%▲21%
Product B123%28%▲26%
Total25%25%25%

Footer

EnableToggle
Default: OnShows or hides the footer row (the row subtotal/total row displayed at the bottom of each group).
StickyToggle
Default: OnPins the footer row to the bottom of the viewport when scrolling. See: Table – Header for example.
Footer Enable — On vs Off
Enable — On (Default)
20242025Total
Brand A24%25%▲24%
Brand B19%23%▲21%
Brand C28%27%▼27%
Brand D30%27%▼28%
Total25%25%25%
Enable — Off
20242025Total
Brand A24%25%▲24%
Brand B19%23%▲21%
Brand C28%27%▼27%
Brand D30%27%▼28%

Number Format

Decimal PointsNumber
Default: 0Number of decimal places shown in all data cells.
PrefixText
Default: (EMPTY)Text prepended before each value (e.g. currency symbol).
SuffixText
Default: %Text appended after each value (e.g. unit of measure).
Number Formats — Various Combinations
0 Decimal Points — % Suffix
20242025Total
Brand A24%25%▲24%
Brand B19%23%▲21%
Brand C28%27%▼27%
Brand D30%27%▼28%
Total25%25%25%
1 Decimal Point — % Suffix
20242025Total
Brand A23.6%24.8%▲24.2%
Brand B19.1%23.4%▲21.3%
Brand C28.2%26.6%▼27.4%
Brand D29.8%27.0%▼28.4%
Total25.2%25.4%25.3%
2 Decimal Points — $ Prefix
20242025Total
Brand A$23.58$24.83▲$24.21
Brand B$19.13$23.38▲$21.25
Brand C$28.25$26.63▼$27.44
Brand D$29.75$26.96▼$28.35
Total$25.18$25.45$25.31
0 Decimal Points — No Prefix / Suffix
20242025Total
Brand A2425▲24
Brand B1923▲21
Brand C2827▼27
Brand D3027▼28
Total252525

Cross-Filtering

Background ColorColor
Default: #FF69B4Background color applied to a selected cell when cross-filtering is active.
Font ColorColor
Default: #ffffffText color of a selected cell when cross-filtering is active.
Hover Background ColorColor
Default: #C2185BBackground color shown when hovering over a selectable cell before clicking.
Hover Font ColorColor
Default: #ffffffText color shown when hovering over a selectable cell before clicking.
Cross-Filtering — Top Left Table — Product B1 Selected
Product B1 — Selected
20242025Total
Brand A24%25%▲24%
Brand B19%23%▲21%
Product B123%28%▲26%
Product B215%19%▲17%
Brand C28%27%▼27%
Total25%25%25%
Filtered Table — Product B1 Only
20242025Total
Brand B22.9%28.1%▲25.5%
Product B122.9%28.1%▲25.5%
Total22.9%28.1%▲25.5%
Other Power BI Visuals — Also Filtered by Product B1
Power BI Line Chart
400300200Sum of CountFeb2025Apr2025Jan2025Jun2024Month
Power BI Matrix
Brand20242025Total
−Brand B1,3771,6833,060
Product B11,3771,6833,060
Total1,3771,6833,060

Significance Testing

Compares each data cell against its preceding time period using a statistical test. Cells that are significantly higher or lower are highlighted using your chosen display style and colours.

Settings

EnabledToggle
Default: OnMaster switch. When off, no significance indicators are shown regardless of other settings.
LevelDropdown
Default: 95%Confidence level for the statistical test. Options: 90%, 95%, 99%. Higher confidence means fewer cells are flagged.
TestDropdown
Default: T-TestStatistical test method. Options: T-Test (better for smaller samples), Z-Test (better for larger samples).
Significance Testing — On vs Off
Enabled — On, 95%, T-Test (Default)
20242025Total
Brand A24%25%▲24%
Brand B19%23%▲21%
Brand C28%27%▼27%
Brand D30%27%▼28%
Total25%25%25%
Enabled — Off
20242025Total
Brand A24%25%24%
Brand B19%23%21%
Brand C28%27%27%
Brand D30%27%28%
Total25%25%25%

Styles

Display StyleDropdown
Default: ArrowsOptions: Arrows, Dot, Cell Fill, Bordered Cell Fill, Underline, Side Rail, Delta Pill.
Higher / Lower Foreground / Background ColorColor
Default: #AEE000 / #F14950Foreground: Color of arrows, dots, borders, rails, and pill text for significantly higher / lower cells. Background: Cell background fill color for significantly higher / lower cells.
Higher / Lower Foreground / Background OpacitySlider
Default: 100%
Border WidthDropdown
Default: 2 pxThickness of the border used by Underline, Side Rail, and Bordered Cell Fill styles.
Display Styles — Examples of All Display Styles
Arrows (Default)
20242025
Brand A24%25%▲
Brand B19%23%▲
Brand C28%27%▼
Brand D30%27%▼
Total25%25%
Dot
20242025
Brand A24%25%
Brand B19%23%
Brand C28%27%
Brand D30%27%
Total25%25%
Cell Fill
20242025
Brand A24%25%
Brand B19%23%
Brand C28%27%
Brand D30%27%
Total25%25%
Bordered Cell Fill
20242025
Brand A24%25%
Brand B19%23%
Brand C28%27%
Brand D30%27%
Total25%25%
Underline
20242025
Brand A24%25%
Brand B19%23%
Brand C28%27%
Brand D30%27%
Total25%25%
Side Rail
20242025
Brand A24%25%
Brand B19%23%
Brand C28%27%
Brand D30%27%
Total25%25%
Delta Pill
20242025
Brand A24%25% +1%
Brand B19%23% +4%
Brand C28%27% −2%
Brand D30%27% −3%
Total25%25%

Typography

Controls font family, size, weight, style, and colour independently for each region of the table: row headers, column headers, data values, row subtotals, column subtotals, the table total column, and the footer row.

Row Header

AlignmentAlignment
Default: Left
Font FamilyFont Picker
Default: Calibri
Font SizeNumber
Default: 14 px
Bold / Italic / UnderlineToggle
Default: Off
Font ColorColor
Default: #000000Applies only to the leftmost row label column.
Row Header — Default vs customised
Default
20242025Total
Brand A24%25%24%
Brand B19%23%21%
Brand C28%27%27%
Brand D30%27%28%
Total25%25%25%
Bold, 15 px, Dark Blue
20242025Total
Brand A24%25%24%
Brand B19%23%21%
Brand C28%27%27%
Brand D30%27%28%
Total25%25%25%

Column Headers

AlignmentAlignment
Default: Center
Font FamilyFont Picker
Default: Calibri
Font SizeNumber
Default: 14 px
Bold / Italic / UnderlineToggle
Default: Off
Font ColorColor
Default: #000000Applies to the header row showing column date/period labels.
Column Headers — Default vs customised
Default
20242025Total
Brand A24%25%24%
Brand B19%23%21%
Bold, 15 px, Dark Blue
20242025Total
Brand A24%25%24%
Brand B19%23%21%

Values

AlignmentAlignment
Default: Center
Font FamilyFont Picker
Default: Calibri
Font SizeNumber
Default: 14 px
Bold / Italic / UnderlineToggle
Default: Off
Font ColorColor
Default: #000000Applies to regular data cells only (not subtotals or totals).
Values — Default vs customised
Default
20242025Total
Brand A24%25%▲24%
Product A128%30%29%
Product A219%20%19%
Brand B19%23%▲21%
Bold, 15 px, Dark Blue
20242025Total
Brand A24%25%▲24%
Product A128%30%29%
Product A219%20%19%
Brand B19%23%▲21%

Row Subtotals

EnableToggle
Default: OffEnables overriding typography styles for subtotal rows.
AlignmentAlignment
Default: Center
Font Family / SizeFont Picker / Number
Default: Calibri, 14 px
Bold / Italic / UnderlineToggle
Default: Off
Font ColorColor
Default: #000000Applies to subtotal rows shown at the bottom of each expanded hierarchy group.
Row Subtotals — Default vs customised
Default
20242025Total
Brand A24%25%▲24%
Product A128%30%29%
Product A219%20%19%
Brand B19%23%▲21%
Bold, 15 px, Dark Blue
20242025Total
Brand A24%25%▲24%
Product A128%30%29%
Product A219%20%19%
Brand B19%23%▲21%

Column Subtotals

EnableToggle
Default: OffEnables overriding typography styles for column subtotal cells.
AlignmentAlignment
Default: Center
Font Family / SizeFont Picker / Number
Default: Calibri, 14 px
Bold / Italic / UnderlineToggle
Default: Off
Font ColorColor
Default: #000000Applies to column subtotal cells (e.g. quarterly, half-year aggregate columns).
Column Subtotals — Default vs customised
Default
Q1Q22024Q1Q2
Brand A22%25%▲24%24%25%
Product A127%30%▲28%29%30%
Product A218%20%▲19%19%20%
Brand B20%19%19%25%▲22%▼
Bold, 15 px, Dark Blue
Q1Q22024Q1Q2
Brand A22%25%▲24%24%25%
Product A127%30%▲28%29%30%
Product A218%20%▲19%19%20%
Brand B20%19%19%25%▲22%▼

Table Total

EnableToggle
Default: OffEnables overriding typography styles for the grand-total column.
AlignmentAlignment
Default: Center
Font Family / SizeFont Picker / Number
Default: Calibri, 14 px
Bold / Italic / UnderlineToggle
Default: Off
Font ColorColor
Default: #000000Applies to the rightmost grand-total column only.
Table Total — Default vs customised
Default
20242025Total
Brand A24%25%24%
Brand B19%23%21%
Brand C28%27%27%
Brand D30%27%28%
Bold, 15 px, Dark Blue
20242025Total
Brand A24%25%24%
Brand B19%23%21%
Brand C28%27%27%
Brand D30%27%28%

Footer

AlignmentAlignment
Default: CenterHorizontal text alignment of the footer row values. Options: Left, Center, Right.
Font FamilyFont Picker
Default: Calibri
Font SizeNumber
Default: 14 px
Bold / Italic / UnderlineToggle
Default: Off
Font ColorColor
Default: #000000Applies to the footer/row-total row text.
Footer Alignment — Center (default) vs Right
Center Aligned (Default)
20242025Total
Brand A24%25%24%
Total25%25%25%
Right Aligned
20242025Total
Brand A24%25%24%
Total25%25%25%
Footer — Default vs customised
Default
20242025Total
Brand A24%25%24%
Brand B19%23%21%
Total25%25%25%
Bold, 15 px, Dark Blue
20242025Total
Brand A24%25%24%
Brand B19%23%21%
Total25%25%25%

Row Styles

Controls background colours and opacity for the row header column, data rows, row subtotals, alternating row shading (zebra striping), and the row hover highlight.

Row Header

Width (px)Number 0–600
Default: 150 pxFixed width of the leftmost row header column.
BackgroundColor
Default: #ffffffBackground color applied to the row header column.
Opacity (%)Slider 0–100%
Default: 100%
Row Header — Width and background
Default (#ffffff)
20242025Total
Brand A24%25%24%
Brand B19%23%21%
Brand C28%27%27%
Brand D30%27%28%
Blue Background
20242025Total
Brand A24%25%24%
Brand B19%23%21%
Brand C28%27%27%
Brand D30%27%28%

Row Subtotals

BackgroundColor
Default: #f0f0f0
Opacity (%)Slider 0–100%
Default: 0%At 0% opacity the row subtotal background is transparent and uses the natural table shading.
Row Subtotals — Transparent vs blue background
0% Opacity (Default)
20242025Total
Brand A24%25%▲24%
Product A128%30%29%
Product A219%20%19%
Brand B19%23%▲21%
Blue Background
20242025Total
Brand A24%25%▲24%
Product A128%30%29%
Product A219%20%19%
Brand B19%23%▲21%

Values

BackgroundColor
Default: #ffffffBase background color applied to all non-shaded data rows.
Opacity (%)Slider 0–100%
Default: 50%
Values — Row background applied to all data rows
Default (White)
20242025Total
Brand A24%25%▲24%
Product A128%30%29%
Product A219%20%19%
Brand B19%23%▲21%
Blue Background
20242025Total
Brand A24%25%▲24%
Product A128%30%29%
Product A219%20%19%
Brand B19%23%▲21%

Shading

EnableToggle
Default: OnAlternates row backgrounds for easier reading across wide tables (zebra striping).
Font ColorColor
Default: #000000Text colour applied to shaded (alternate) rows.
Row BackgroundColor
Default: #ffffff
Row Opacity (%)Slider 0–100%
Default: 70%
Row Shading — Off vs On (default) vs custom colour
Shading Off
20242025Total
Brand A24%25%24%
Brand B19%23%21%
Brand C28%27%27%
Brand D30%27%28%
Shading On (Default)
20242025Total
Brand A24%25%24%
Brand B19%23%21%
Brand C28%27%27%
Brand D30%27%28%
Custom shading colour
Blue-tinted alternating rows
20242025Total
Brand A24%25%24%
Brand B19%23%21%
Brand C28%27%27%
Brand D30%27%28%

Hover

EnableToggle
Default: OnHighlights the entire row when the cursor moves over it, making it easier to read across many columns.
Font ColorColor
Default: #ffffff
Row BackgroundColor
Default: #12239E
Row Opacity (%)Slider 0–100%
Default: 30%
Row Hover — Brand B row is hovered
Default hover colour (30% blue overlay, white text)
20242025Total
Brand A24%25%24%
Brand B19%23%21%
Brand C28%27%27%

Column Styles

Controls background colours and opacity for column headers, column subtotals, the table total column, alternating column shading, the column hover highlight, and the footer row background.

Column Headers

Background ColorColor
Default: #ffffff
Background Opacity (%)Slider 0–100%
Default: 80%Background of the entire header row (period labels). Typography > Column Headers controls the text appearance.
Column Headers — Default vs blue background
Default (White, 80%)
20242025Total
Brand A24%25%24%
Brand B19%23%21%
Blue Background
20242025Total
Brand A24%25%24%
Brand B19%23%21%

Column Subtotals

BackgroundColor
Default: #f0f0f0
Opacity (%)Slider 0–100%
Default: 0%Background of column subtotal cells (e.g. quarterly or half-year aggregate columns).
Column Subtotals — Transparent vs blue background
0% Opacity (Default)
Q1Q22024Q1Q2
Brand A22%25%▲24%24%25%
Product A127%30%▲28%29%30%
Product A218%20%▲19%19%20%
Brand B20%19%19%25%▲22%▼
Blue Background
Q1Q22024Q1Q2
Brand A22%25%▲24%24%25%
Product A127%30%▲28%29%30%
Product A218%20%▲19%19%20%
Brand B20%19%19%25%▲22%▼

Table Total

BackgroundColor
Default: #f0f0f0
Opacity (%)Slider 0–100%
Default: 0%Background of the rightmost grand-total column.
Table Total — Transparent vs blue background
0% Opacity (Default)
20242025Total
Brand A24%25%24%
Brand B19%23%21%
Blue Background
20242025Total
Brand A24%25%24%
Brand B19%23%21%

Shading

EnableToggle
Default: OffAlternates column backgrounds (zebra striping by column rather than by row).
Font ColorColor
Default: #000000
Column BackgroundColor
Default: #ffffff
Column Opacity (%)Slider 0–100%
Default: 70%
Column Shading — Off (Default) vs On
Shading Off (Default)
AprFebJanJunMar
Brand A24%25%22%▼26%▲24%▼
Product A129%29%26%▼31%▲28%▼
Product A219%20%18%21%▲19%
Brand B20%25%▲19%▼20%23%▲
Column Shading On
AprFebJanJunMar
Brand A24%25%22%▼26%▲24%▼
Product A129%29%26%▼31%▲28%▼
Product A219%20%18%21%▲19%
Brand B20%25%▲19%▼20%23%▲

Hover

EnableToggle
Default: OnHighlights the entire column when hovering over any cell within it.
Font ColorColor
Default: #ffffff
Column BackgroundColor
Default: #12239E
Column Opacity (%)Slider 0–100%
Default: 30%
Column Hover — 2025 column is hovered
Default hover colour (30% blue overlay, white text)
20242025Total
Brand A24%25%24%
Brand B19%23%21%
Brand C28%27%27%

Footer

Background ColorColor
Default: #F0F0F0Background of the footer (row subtotal/total) row.
Background Opacity (%)Slider 0–100%
Default: 80%
Footer — Default vs blue background
Default (#F0F0F0, 80%)
20242025Total
Brand A24%25%24%
Brand B19%23%21%
Total25%25%25%
Blue Background
20242025Total
Brand A24%25%24%
Brand B19%23%21%
Total25%25%25%