Visuals/Pl. VI

    Crosstab

    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, and a 30,000-row banner that scrolls like a native table.

    Datasheet
    Status
    Available on Microsoft Marketplace
    Price
    $1.99 /user/mo · $19 /user/yr
    Licensing
    Per user, assigned in the Microsoft 365 admin center. Unlicensed viewers see the free tier, never a blocked visual.
    Data
    Computed inside Power BI. No external calls, no API keys, no telemetry.
    Visuals API
    5.11
    Accessibility
    One keyboard tab stop with arrow navigation across cells, Windows high contrast
    Languages
    English, Czech
    Methodology
    Published at /research/methodology; engine validated against R and scipy
    Works in
    Power BI Desktop, Service, Embedded
    Pl. VI  ·  Crosstab  ·  the product spotrecorded from the shipped visual
    Survey crosstab in Power BI with significance letters, Top 2 Box and mean rows
    Pl. VI  ·  Crosstab  ·  Banner table by department with letters, Top 2 Box and mean rows, base row, the smart caption and the footnote (premium letters).rendered from the shipped visual
    What it does

    SmartVisuals Crosstab is the survey banner table as a Power BI visual. Map Question, Answer and a Value, add the banner columns, and the table appears with sticky headers, a Total column, a base row per question block, heat shading by share, tooltips and cross-filtering by cell. It is virtualized, so a banner with thousands of rows scrolls like a native table and keeps your place across filters.

    The premium tier is the inference: column proportion z-tests between banner columns with A/B/C letters at 90, 95 or 99 percent confidence, weighted cells on Kish effective bases, top and bottom box net rows and mean rows with Welch-test letters, the index against Total, and a test on every tracker delta. Every statistic is computed offline inside the visual; the methodology is published and the engine is validated against R and scipy.

    Free and premium

    Where the line is, exactly.

    Report authors see the full premium set in edit mode, so you can evaluate every feature on your own data before assigning a single licence. Unlicensed viewers always get a working chart.

    Free tierevery viewer
    • The tableColumn % or values (or both), decimals, a Total column, base row per block, heat shading by share, sticky headers, tooltips and cross-filtering by cell.
    • Tracker modeAdd a Wave field and every cell shows the latest wave with the change since the previous one, plus a trend column.
    • Table toolsSearch, transpose, and CSV export that keeps the letters. Row virtualization for a 30,000-row banner.
    • Says the findingA smart caption stating how many cells differ, an agency footnote with the base, the effective n under weighting, wave and source, and Quick Styles.
    • Every cosmetic optionFour built-in themes, four fonts, font size and colour, cell shading by %, letter colour and a transparent background. English and Czech.
    Premium$1.99 /user/mo · first month free
    • Significance lettersColumn proportion z-tests between banner columns at 90, 95 or 99 % confidence, optional Bonferroni correction, low bases flagged with * and excluded. Never a fabricated significance.
    • Weighted cellsMap Sum of Weight and Sum of Weight squared for Kish effective bases, the SPSS-style convention.
    • Net and mean rowsTop and bottom box nets (one to three points) and mean rows with Welch-test letters, per question block.
    • Index vs Total and tracker tests▲ ▼ marks on cells significantly above or below the rest of the sample, and a test on every change since the previous wave.

    Crosstabs in Power BI: what the matrix visual cannot do

    A survey banner table is a matrix with rules. Questions are stacked as blocks, segments run across as columns, cells show column percentages on a base that is printed under the header, and where a cell is significantly higher than another column it carries that column's letter. The native matrix visual can stack questions and show percentages; it cannot compute a base row per block, cannot weight cells on effective bases, and has no idea what a column proportion test is.

    SmartVisuals Crosstab is that banner table as a visual. Map Question, Answer and Value, add Columns for the banner, and the table appears with sticky headers, a Total column, a base row per block, heat shading by share and cross-filtering by cell. The letters, the weighting and the net and mean rows are the premium layer on top.

    What the A/B/C letters mean

    Each banner column gets a letter. A letter inside a cell says that this cell's percentage is significantly higher than the same cell in the column with that letter, at the confidence level you chose: 90, 95 or 99 percent. The test is a two-sample z-test on column proportions, the SPSS-style convention, with optional Bonferroni correction for the number of comparisons in a block.

    Columns with a base below your threshold are flagged with an asterisk and excluded from testing, so a letter never appears on ten respondents. The footer explains the letters and marks, and the rule is printed, not implied. The full method, including the documented column-overlap limitation, is on the methodology page.

    Weighted cells and effective bases

    Weighted surveys need two things from a table: percentages on the weighted counts and tests on the effective base, not the weighted one. Map Sum of Weight as the value and Sum of Weight squared next to it, and the visual computes the Kish effective base per column, n_eff = (Σw)² / Σw², and runs every test on it. The footnote prints the base and, under weighting, the effective n next to it.

    Unweighted tables work with a plain respondent count and no second measure; the letters then use the raw base.

    Nets, means and the index against Total

    Top box and bottom box net rows summarize a scale question in one line, one to three scale points each, and carry their own letters. Mean rows put the scale mean under the block with Welch-test letters between columns. An index view shows each cell against the Total column, with diverging shading and marks for cells above or below the rest of the sample.

    Tracker mode, search, export and 30,000 rows

    Add a Wave field and the table shows the latest wave with the change since the previous one in every cell, plus a trend column; each delta is tested in the premium tier. A search box finds a question or answer in a long banner, transpose swaps rows and columns, focus mode dims every cell without a letter, and CSV export writes the table with its letters so it can go into a deck or a client file.

    The table is virtualized, so a 30,000-row banner scrolls like a native table and keeps your place across cross-filters. The smart caption says how many cells differ, the agency footnote prints the base, the effective n under weighting, wave and source, and Quick Styles set the look in one click.

    Getting started

    From empty canvas to first chart.

    1. 01

      Map Question, Answer and Value (respondent count, or Sum of Weight for weighted results). The table renders with a Total column and base row.

    2. 02

      Add Columns (banner) for the segments you compare across.

    3. 03

      Add Sum of Weight squared to enable effective bases for weighted letters (premium), and Wave / Period for tracker mode.

    4. 04

      Turn on net rows, mean rows or the index view in the format pane; pick a Quick Style.

    Get Crosstab

    Two ways in.

    Installation instructions for both paths are on the download page.

    Microsoft Marketplace (recommended)

    Reviewed by Microsoft, updates automatically, licences assigned in the Microsoft 365 admin center.

    Open Microsoft Marketplace

    Direct download (1.0.1.0)

    .pbiviz package, import into Power BI Desktop or Service, does not auto-update. Includes the full free tier; premium features preview in edit mode and are licensed through Microsoft Marketplace.

    Download .pbiviz
    Accessibility

    Readable and usable for everyone.

    Tab
    Move to the search box and the CSV button when they are shown, then into the table. The table itself is a single tab stop.
    Arrow keys
    Move from cell to cell. Left and Right wrap onto the next row.
    Home / End
    Jump to the first or last cell.
    Page Up / Page Down
    Jump about ten rows back or ahead.
    Enter or Space
    Cross-filter the report by the focused cell.
    Ctrl+Enter or Ctrl+Space
    Add the focused cell to the selection.
    Esc
    Clear the selection.
    • High contrast

      In Windows high contrast the table uses the foreground and background colours Power BI hands it instead of the theme. Heat shading is switched off and low bases stay hatched.

    • Screen readers

      When the table takes focus its accessible name is the smart caption, so the finding is read first. Each cell carries a label with its row, column and value. The search box is labelled.

    • Not colour alone

      Significance is shown with column letters, ▲ and ▼ marks and a ✓ on tested changes. Low bases are hatched and starred in the base row.

    • Languages

      English and Czech, including the format pane, the caption, the footnote and the footer that explains the letters.

    Release notes

    What changed, and when.

    Updates install automatically from Microsoft Marketplace. Full history.

    1. 1.0.1.0

      First release on Microsoft Marketplace.

      • Banner tables with tracker mode and the finding written out under the table.
      • Significance letters, weighted cells, net and mean rows (premium).
      • Right-click context menu on empty space.
    Questions

    Asked before you did.

    More questions? See support or write to hello@smartvisuals.io.

    Missing something?

    Tell us what is missing.

    A feature you need, a bug you hit, a visual that does not exist yet. Every message reaches the person who builds these visuals, and feature requests shape what ships next. We also build visuals to order.

    Also in the family