Skip to main content
Don’t miss what’s next at Microsoft Ignite
Don’t miss what’s next at Microsoft IgniteGet direct access to the people, products, and expertise behind Microsoft technology, with opportunities to ask questions, build skills, and learn alongside the community.
Register now
Microsoft
separator
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-crosstab-c216124d-1698-40c6-9ea8-569f01a90680/image3_icon300.png

Crosstab by SmartVisuals

by SmartVisuals.io

Free Trial
Download SampleInstructions

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.

Visual capabilities

This visual is certified by Power BI

At a glance

https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-crosstab-c216124d-1698-40c6-9ea8-569f01a90680/image1_shot1hero.png
/staticstorage/20261108.1/assets/videoOverlay_62a424ca921ff733.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-crosstab-c216124d-1698-40c6-9ea8-569f01a90680/image1_shot1hero.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-crosstab-c216124d-1698-40c6-9ea8-569f01a90680/image2_shot2tracker.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-crosstab-c216124d-1698-40c6-9ea8-569f01a90680/image0_shot3cells.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-crosstab-c216124d-1698-40c6-9ea8-569f01a90680/image4_shot4themes.png
English (United States)
Your Privacy Choices Opt-Out Icon Your Privacy Choices
Consumer Health Privacy Sitemap Contact Us Privacy & Cookies Terms of Use About our ads Manage cookies