Visuals/Pl. VII

    Likert

    Likert batteries, done like a research agency

    Diverging stacked bars with the neutral split on the axis, N/A detached, top and bottom box nets, means on the scale, and significance letters between segments on weighted effective bases. Map Question, Answer and a Value; that is the whole setup.

    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
    Single-tab-stop keyboard navigation, Windows high contrast, captions read by screen readers
    Languages
    English, Czech
    Methodology
    Published at /research/methodology; engine validated against R and scipy
    Works in
    Power BI Desktop, Service, Embedded
    Pl. VII  ·  Likert  ·  the product spotrecorded from the shipped visual
    Likert battery in Power BI in tracker mode with dimension score bars, tested change and benchmark deltas
    Pl. VII  ·  Likert  ·  Employee survey battery in tracker mode: dimension score bars, the tested change since the previous wave, margins of error, benchmark deltas, the smart caption and the footnote.rendered from the shipped visual
    What it does

    SmartVisuals Likert is the battery chart insights teams put in their decks, as a Power BI visual. Diverging stacked bars centred on the axis, the neutral answer auto-centred or placed where you want it, N/A detached with an explicit base choice, top and bottom box nets, means, margins of error, bases per statement and sorting by top box. A tracker mode shows the change since the previous wave, a Group field turns the battery into sections with pooled score bars, and a Benchmark measure shows the delta against your norm.

    The premium tier adds the statistics: segments lettered A/B/C against each other on Kish effective bases, and tests of every statement against the rest of the battery, against your benchmark and against the previous wave. Every number 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 best unweighted Likert rendering on the shelfNeutral auto-centred, custom or none; reverse scale; a collapsed disagree / neutral / agree view; N/A detached with in or out-of-base choice; % labels with a minimum-size threshold; sorting by top box; legend; bases (n=); means; margins of error; an All statements row.
    • Tracker modeAdd a Wave field and the bars show the latest wave with the change of every top box since the previous one.
    • Dimensions and benchmarksA Group field turns the battery into sections with pooled score bars; a Benchmark measure shows the delta against your norm on every statement; a Question Text field carries full wording into tooltips.
    • Says the findingA smart caption with the highest and lowest statement, the strongest dimension and what beats the norm; an agency footnote with base, weighted and effective n and source; Quick Styles.
    • Every cosmetic optionFour themes, fonts, positive / negative / neutral ramps, a colour swatch per answer named by the answer itself, corner radius, bar thickness and gaps between segments.
    Premium$1.99 /user/mo · first month free
    • Segment comparisonAdd a Segment field and every statement splits into groups lettered A/B/C against each other; low bases hatched, flagged with * and excluded from tests; the footer explains the letters.
    • Weighted resultsMap Sum of Weight and Sum of Weight squared and every percentage and test uses Kish effective bases.
    • Vs-total, vs-benchmark and wave testsEach statement's top box tested against the rest of the battery (up / down markers), against your norm (check mark) and against the previous wave, at 90, 95 or 99 % confidence.

    Likert charts in Power BI: where the stacked bar goes wrong

    A Likert battery is usually drawn as a 100 percent stacked bar, and that is where the trouble starts. The neutral answer sits somewhere in the middle of the bar, so agree and disagree cannot be compared across statements. N/A answers are either dropped silently or counted in the base. And a battery of twenty statements sorted by data-load order is a wall, not a chart.

    SmartVisuals Likert draws the battery the way a research agency does: diverging bars centred on the axis with the neutral split in two, N/A detached to the side with an explicit in or out-of-base choice, top and bottom box nets at the ends, means on the scale, and sorting by top box so the strongest statement is at the top. Map Question, Answer and a Value; that is the whole setup.

    Neutral, N/A and reverse scales

    The neutral category can be auto-centred so half sits on each side of the axis, placed at a custom position, or removed from the diverging view. N/A is detached from the bar and you decide whether it counts in the base. If your answer codes run from agree to disagree, Reverse Scale Order flips the scale for the whole battery. Percent labels hide below a minimum segment size so a 2 percent slice does not print over its neighbour.

    A collapsed view reduces the scale to disagree / neutral / agree for executive audiences, and an All statements row summarizes the battery in one bar. Bases (n=), means and margins of error print per statement.

    Tracker mode, dimensions and benchmarks

    Add a Wave field and the bars show the latest wave, with the change of every top box since the previous one next to it. Add a Group field and the battery breaks into sections, Leadership, Tools, Workload, each with a pooled score bar as its header. Add a Benchmark measure and every statement shows its delta against your norm, and a Question Text field carries the full wording into tooltips when your question codes are short.

    Significance letters between segments

    Add a Segment field in the premium tier and every statement splits into groups lettered A/B/C against each other on weighted effective bases: a letter on a group's top box says it is significantly higher than the group carrying that letter. Low bases are hatched, flagged with an asterisk and excluded from testing, and the footer explains the letters.

    Three further tests run per statement: against the rest of the battery (up and down markers), against your benchmark (a check mark) and against the previous wave, at 90, 95 or 99 percent confidence. Map Sum of Weight and Sum of Weight squared and every percentage and test uses Kish effective bases.

    Says the finding, in your language

    The smart caption names the highest and lowest statement, the strongest dimension and what beats the norm, offline, localized, and read out by screen readers. The agency footnote prints base, weighted and effective n and source. Quick Styles switch the whole look between Agency deck, Executive summary and Compact tracker in one click, and every cosmetic option stays free: four themes, fonts, positive, negative and neutral ramps, a colour swatch per answer named by the answer itself, corner radius, bar thickness and gaps.

    Getting started

    From empty canvas to first chart.

    1. 01

      Map Question, Answer (scale) and Value (respondent count, or Sum of Weight for weighted results). Sort the answer field by column so the scale is in order.

    2. 02

      Choose the neutral handling, N/A base rule and sorting in the format pane, or pick a Quick Style.

    3. 03

      Add Wave / Period for tracker mode, Dimension / Group for sections and Benchmark (top box) for your norm.

    4. 04

      Add Segment (comparison) and Sum of Weight squared for lettered, weighted comparisons (premium).

    Get Likert

    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
    Moves into the chart. The whole visual is one tab stop, and focus lands on the first bar segment.
    Down arrow / Right arrow
    Moves to the next bar segment, answer by answer along a statement and then on to the next statement. Stops at the last segment.
    Up arrow / Left arrow
    Moves to the previous bar segment. Stops at the first segment.
    Page Down / Page Up
    Jumps ten segments forward or back.
    Home / End
    Jumps to the first or the last segment.
    Enter / Space
    Cross-filters the report to the focused segment.
    Ctrl+Enter / Ctrl+Space
    Adds the focused segment to the current selection instead of replacing it.
    Escape
    Clears the selection.
    • High contrast

      In Windows high contrast mode the bars, labels, legend, caption and footnote take the system foreground and background colours. Answers become shades between the two with an outline on every segment, and the transparent background and custom answer colours are switched off so nothing fades into the page.

    • Screen readers

      The chart is one labelled region whose name is the smart caption, for example the highest and lowest statement and what beats the norm, so a screen reader reads the finding first. Each bar segment carries a label with the statement, the answer and its share, such as Workload, Agree: 34%, and the full question wording is attached to each statement label.

    • Not colour alone

      Disagree answers sit left of the axis and agree answers right of it, so the direction reads from position. Changes and test results carry glyphs as well as colour: ▲ or ▼ for a change or a significant difference, ✓ for a significant result, letters for segment differences, and an asterisk plus hatching for a base too small to test.

    • Focus ring

      The focused segment gets a dashed outline in the text colour, and in a long battery the plot scrolls so the focused segment stays in view.

    • Languages

      English and Czech for the format pane, the smart caption, the footnote and the empty-state help. Other Power BI locales show the English strings.

    Release notes

    What changed, and when.

    Updates install automatically from Microsoft Marketplace. Full history.

    1. 1.0.1.0

      First release on Microsoft Marketplace.

      • Diverging Likert battery with neutral and N/A handling, nets and means; tracker mode.
      • Segment comparison with significance letters and weighted results (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