Pareto Chart by SmartVisuals
Pareto analysis with vital-few detection, ABC zones, insights and comparison - no DAX needed
Pareto analysis, not just a Pareto chart. Drop in a category and a measure and get a correct Pareto instantly: bars ranked by contribution, cumulative percentage line, vital-few detection and an insight sentence - all computed in the visual, no DAX patterns to maintain.
Correct by default. Deterministic ordering with tied values, stable sort in Power BI Desktop and the Service, automatic aggregation of duplicate categories, percentage and currency measures via your model format strings, and high-cardinality data loaded in full (up to 30,000 categories) with a configurable Others bar instead of scroll bars.
Free features:
- Automatic cumulative % line, threshold line at any percent (default 80/20) and one extra reference line with label
- Axis titles, bar-axis range, display units and decimals, line markers (shape, size)
- Vital-few / trivial-many bar coloring, per-category colors and fx conditional formatting
- Top-N with Others grouping, bar values and cumulative % labels
- Vital-few insight sentence ("7 of 212 categories drive 80% of the total")
- 5 built-in themes, report theme colors, transparent background
- Format on the canvas (on-object formatting): click a bar, axis, label or line and change its color, font or visibility in place
- Cross-filtering, drill hierarchies, bookmarks, tooltips, high contrast, keyboard navigation, localization in 20 languages
- Renders up to 15 individual categories plus Others, with every statistic computed on all your categories (reports created before version 1.2.0.0 keep 25)
Premium features (per-user license via Microsoft AppSource):
- More individual categories: up to 200 bars (Max bars) before Others
- ABC classification: A/B/C zones with custom cutoffs (80/95/100), zone shading, labels and tooltip classes
- Smart Insights+: headline callout (Top 7 of 212 = 80.3%) and annotated threshold intersection
- Second and third reference line
- QM mode: quality data table (rank, value, %, cumulative %) beside the chart
- Before/after comparison: two periods side by side with rank-change markers - built for quality management reviews
- Small multiples: one Pareto per plant, line or region
- Metric switching across measures (count vs. cost) and a second cumulative line
Every premium feature is fully unlocked while editing, so you can evaluate everything before buying. Unlicensed viewers always see a working chart (free tier plus Others) - never a broken or watermarked visual. No data leaves Power BI: the visual makes no external calls.
Built for quality engineers (defect Paretos, ISO 9001, Six Sigma), sales and inventory analysts (revenue and SKU concentration) and anyone tired of maintaining cumulative-percentage DAX.
Support: https://smartvisuals.io/support - hello@smartvisuals.io