Bullet Chart by SmartVisuals

The bullet chart for review meetings. Put Actual next to Target, Forecast and Prior year and see at a glance which lines are on target, by how much, and whether you will make the year. Bands, status and variance are computed in the visual - no DAX - and premium adds a summary sentence that says what the chart shows.

Free features:

• Actual vs Target for unlimited rows, horizontal or vertical, or as KPI tiles
• Bands from % of target (80/100 by default) or from your own measures, plus an optional stretch band
• Lower-is-better KPIs (costs, scrap, lead time): bands, colours and variance flip, for the whole visual or per row
• Status icons with distinct shapes, so status never depends on colour alone
• Data labels: variance (absolute and %), target labels and category labels, plus a variance bar; shared axis with grid lines, display units and decimals
• Target marker as a line, full-height line, line with arrows or triangle
• Drill-down on the category: put a hierarchy on Category, drill down or expand all levels
• Two constant reference lines with labels, named in the legend
• Legend that names Actual, Target, Forecast, Prior year, bands, pace markers and reference lines by your measure names, with top or bottom position, font, size, colour and an optional title
• Small multiples: group sections or side-by-side group panels with an on-target count per group
• IBCS notation: AC and PL labels with absolute and relative variance columns
• Sort worst first, best first or by largest gap; Top N with Others
• Per-row units or format strings from a measure (Unit or format field) for mixed-unit scorecards: 96.1%, 12.6 days, 0.42 per 200k h, variance in percentage points
• Dynamic format strings and calculation groups: every value keeps the format your model gives it
• Four themes with their own personality, report theme colours, automatic good/warning/bad status colours
• Conditional formatting: per-category colours accept Power BI fx rules, gradients or a field value
• Cross-filtering and cross-highlighting, multi-select, right-click context menu, tooltips and report page tooltips
• Format on the canvas (on-object formatting): click a bar, marker, band, label or the legend in Power BI's format mode to change its colour, text or visibility in place
• Localized in 20 languages (format pane, tooltips and screen-reader text): English, Czech, Danish, Dutch, French, German, Hungarian, Italian, Japanese, Korean, Norwegian, Polish, Portuguese (Brazil and Portugal), Slovak, Spanish, Swedish, Turkish, Chinese (Simplified and Traditional)

Accessibility (free): keyboard navigation with one tab stop, arrow keys, Home/End, Enter or Space to select, Esc to clear and Shift+F10 for the context menu; a visible focus outline; screen-reader labels that read each row's values, variance and status; status shapes as a non-colour cue; high contrast mode support. The Accessibility card sets the focus outline colour and width and a minimum text size. The chart does not animate.

Premium features ($1.99 per user per month or $19 per user per year, first month free; per-user licence via Microsoft Marketplace):

• Forecast, Prior year and Second target comparisons in the same row (AC, PL, FC, PY, PL2), with prior year as a dot or as a bar behind the actual and the second target as a dashed marker
• Pace to target: run-rate projection and where you should be by today (year, quarter or month to date, a fixed % or a field)
• Trend sparkline per row or tile, with the target line
• % of target scale: KPIs in different units on one axis
• Variance pin column next to the rows (IBCS style)
• Smart insight: "9 of 15 off target. Largest gap: Scrap rate (+31.8%)"

Every premium feature is fully unlocked while you edit, so you can evaluate everything before buying. Viewers without a licence always see a working chart in the free tier - never a blocked or watermarked visual, and your settings are never reset. No data leaves Power BI: the visual makes no external calls.

New in 1.1.0.0: drill-down on the category, two labelled reference lines, legend font, size, colour and title, format on the canvas, dynamic format strings, and a Second target field (premium). Everything that was free stays free.

Built for controllers and FP&A (plan, forecast and prior year reviews), sales operations (quota attainment and pace) and plant managers (safety, quality, delivery and cost scorecards).

Documentation: https://smartvisuals.io/visuals/bullet-chart - Support: https://smartvisuals.io/support#bullet-chart - Release notes: https://smartvisuals.io/changelog#bullet-chart - hello@smartvisuals.io