Skip to main content
Convergent Business TechnologiesBook a Call
Power BI · Microsoft AppSource

Pareto Chart

Sort causes largest first, accumulate them, and mark the vital few that reach your threshold.

Coming soonWatch tutorial
Preview of Pareto Chart

What it does.

Most of the problem usually sits in a handful of causes. The Pareto chart is the standard way to find them: bars sorted largest first, a cumulative line climbing across them, and a threshold separating the vital few worth acting on from the trivial many that are not.

Power BI can draw sorted bars and a line on a second axis, but it will not sort by value, accumulate the percentages, work out where the line crosses your threshold, or tell you how many categories that took. Those are the parts that make it a Pareto chart rather than a combo chart, and they are the parts this visual does for you.

The cut is not fixed at 80 percent. Set any threshold, and the chart marks the crossing point and states in plain words how many categories reach it. A long tail can be rolled into a single Other bar so the chart stays readable without losing the total.

Use Cases • Which defect types account for most of the scrap • Which customers or products make up most of the revenue • Which error codes drive most of the support tickets • Which cost lines to attack first in a reduction program • Which suppliers cause most of the late deliveries

What ships today, what’s next.

Available now16 capabilities

  • Bars sorted largest first, with a computed cumulative percentage line
  • Adjustable threshold, not fixed at 80 percent
  • Cut line marking where the cumulative line crosses the threshold
  • Plain-words callout of how many categories reach it
  • Separate colours and labels for vital few and trivial many
  • Tail grouping into a single Other bar
  • Independent value and percentage axes
  • Data labels: all bars, vital few only, or those that fit
  • Automatic category label rotation
  • Threshold line and cut line, independently formatted
  • Small multiples, each sorted and cut on its own data
  • Explicit handling of blanks and negatives, with an exclusions notice
  • Cross-filtering, drill-down, report page tooltips, bookmarks
  • Keyboard navigation and screen-reader accessibility
  • High-contrast mode support
  • Landing page quick-start guidance

On the roadmap1 planned

  • A second cumulative series for period comparison

Other custom visuals.

23 more visuals in the catalogue. All free to download.

01Free · AppSource

Waffle Chart

Show part-to-whole proportions, track progress toward targets, or break totals by category.

Learn more →
02Free · AppSource

Histogram

Interactive histogram for visualizing the distribution of a continuous measure, with flexible binning, weighted bin heights, and built in statistical overlays.

Learn more →
03Free · AppSource

Dual Hierarchy Decomposition Tree Pro

DAX-driven KPI tree with dual-axis drill-down, per-KPI colors, icons, and Microsoft-certified Pro features.

Learn more →
04Free · AppSource

Advanced Sankey Diagram

Interactive Power BI Sankey diagram for visualizing multi-stage flow data, with automatic node-to-ribbon color gradients and rule-based conditional formatting.

Learn more →
05Free · AppSource

Sparkline KPI Card

KPI Card with Sparkline for Power BI that displays KPI values, previous period comparisons, targets, variance, trend indicators, and interactive sparklines in a compact, business-ready visual.

Learn more →
06Free · AppSource

Cluster Analysis Chart

A scatter plot that groups points into clusters by similarity using K-Means, DBSCAN, or Hierarchical clustering. Shows centroids, hulls, ellipses, outliers, and dendrograms, with no R or Python.

Learn more →
07Free · AppSource

Lollipop Chart

Compare one value across many categories with clean stems and markers on a shared scale, and track each category against its target.

Learn more →
08Free · AppSource

Bullet Chart

Compare performance against multiple targets with qualitative bands, variance, and small multiples.

Learn more →
09Free · AppSource

Advanced Gantt Chart

Interactive Gantt chart for visualizing hierarchical project schedules, with automatic parent task rollups, dual baseline and actual timeline bars, and rule-based conditional formatting.

Learn more →
10Free · AppSource

Radial Histogram

Interactive radial histogram, wedges radiating from a center point, area-correct by default.

Learn more →
12Free · AppSource

Win Loss Chart

A win/loss sparkline for Power BI. Each period is one equal-sized mark above or below a baseline, so streaks and form are visible at a glance across many rows at once.

Learn more →
13Free · AppSource

Dual Axis Bar & Column Chart

Plot two measures on independent scales without dropping in a separate combo chart.

Learn more →
14Free · AppSource

Dual Hierarchy Decomposition Tree

Up to four KPIs per card across two hierarchy axes, with DAX-driven status colours.

Learn more →
15Free · AppSource

Multi KPI Decomposition Tree

Decompose up to five measures per node, with stacked bars on every branch.

Learn more →
16Free · AppSource

Arabic Matrix Table

Right-to-left matrix with Arabic labels, hierarchical rows, subtotals and grand totals.

Learn more →
17Free · AppSource

Arabic Stacked Bar Chart

RTL-native stacked bars with Arabic number units, small multiples and cross-filtering.

Learn more →
18Free · AppSource

Arabic Stacked Column Chart

RTL-native stacked columns matched to the Arabic Bar visual for consistent dashboards.

Learn more →
19Free · AppSource

Arabic Waterfall Chart

Sequential value walk for Arabic dashboards — variance, build-up and bridge analyses.

Learn more →
20Free · AppSource

Dumbbell Chart

Two markers per category on a shared scale, connected by a line that makes the gap immediately visible.

Learn more →
21Free · AppSource

Counts Plot

Visualise data distribution with dots scaled by frequency across category lanes.

Learn more →
22Free · AppSource

Jitter Plot

Show every data point with jitter or beeswarm layout for distribution analysis.

Learn more →
23Free · AppSource

Auto Single Select Slicer

Smart Power BI slicer with automatic first-value selection — reports never load with an empty filter.

Learn more →
24Free · AppSource

AutoSelect Slicer

Smart Power BI slicer with automatic selection across single-select and multi-select scenarios.

Learn more →

Need a custom Power BI visual built for your reporting?

Thirty minutes with a senior BI consultant. We’ll walk your report, scope the visual, and tell you whether a build makes sense.

Talk to our BI team →