Crosstab by SmartVisuals
Survey crosstabs with significance letters, weighted bases, net and mean rows - inside Power BI.
The banner table every insights team ships - inside Power BI. Questions as blocks, segments as columns, column % with A/B/C letters where a cell is significantly higher. Sticky headers, base row, heat shading; virtualized, so a 30,000-row banner scrolls like a native table and keeps your place across cross-filters.
Free forever - and never blocked
- The table: column % or values (or both) or an index vs Total with diverging shading, decimals, Total column, base row, heat shading by share, transpose, a search box, margins of error in every tooltip, 4 themes, tooltips, cross-filtering by cell.
- Tracker mode: add a Wave field and the table shows the latest wave.
- Says the finding: a smart caption that names the most chosen answer and, with premium, counts the significant cells and names the biggest gap and the biggest move; an agency footnote with base, effective n, wave and source; a footer that explains the letters; Quick Styles.
- Format on the canvas (on-object formatting): in format mode click a cell, a header or a letter and style it in place.
- No lock-out, ever. Unlicensed viewers always see the full free tier - no watermark, no broken visual.
Premium: the inference (per-user license)
- Tracker deltas and CSV export: every cell shows the change since the previous wave in percentage points, with a Trend column over all waves; CSV export keeps the letters native export drops.
- Significance letters: column proportion z-tests between banner columns, 90 / 95 / 99 % confidence, optional Bonferroni; low bases flagged with * and excluded - never a fabricated significance; focus mode dims every cell without a letter.
- Weighted cells: map Sum of Weight and Sum of Weight2 for Kish effective bases, the convention behind agency column tests.
- Net and mean rows: top / bottom box nets (1-3 points) and mean rows with Welch-test letters, per question block.
- Tested tracker deltas: a check mark on every change since the previous wave that is significant.
- Vs-Total test: ▲ ▼ where a segment's cell is significantly above / below the rest of the sample.
Try before you buy: every premium feature previews free in edit mode. Licenses are per user, purchased on AppSource and assigned in the Microsoft 365 admin center. Part of the SmartVisuals Research suite - the same engine also powers SmartVisuals Likert, SmartVisuals NPS and the all-in-one SmartVisuals Research visual.
Built properly
- Fully offline, no telemetry; methodology published; engine validated against R and scipy.
- Accessible: one keyboard tab stop with arrow navigation across cells, Windows high contrast; localized in 20 languages.
New in 1.1.0.0: format on the canvas (on-object formatting), dynamic format strings and 20 languages, all free. For visuals added from 1.1.0.0 on, tracker deltas with the Trend column and CSV export are Premium; reports created before 1.1.0.0 keep them as they were.
Questions or feature requests: hello@smartvisuals.io - we read every message.