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-pareto-28838a6b-3aa1-4e46-ba02-cebbd40fe612/image5_icon300.png

Pareto Chart by SmartVisuals

by SmartVisuals.io

Free Trial
Download SampleInstructions

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

Visual capabilities

This visual is certified by Power BI

At a glance

https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-pareto-28838a6b-3aa1-4e46-ba02-cebbd40fe612/image1_01classic8020.png
/staticstorage/20261108.1/assets/videoOverlay_62a424ca921ff733.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-pareto-28838a6b-3aa1-4e46-ba02-cebbd40fe612/image1_01classic8020.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-pareto-28838a6b-3aa1-4e46-ba02-cebbd40fe612/image0_02abczones.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-pareto-28838a6b-3aa1-4e46-ba02-cebbd40fe612/image2_03qmcomparison.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-pareto-28838a6b-3aa1-4e46-ba02-cebbd40fe612/image3_04insightscallout.png
https://catalogartifact.azureedge.net/publicartifacts/smartvisuals.smartvisuals-pareto-28838a6b-3aa1-4e46-ba02-cebbd40fe612/image4_05themes.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