Pareto Chart

80/20 Analysis Chart

DAX

DAX

pareto-chart

Overview

Features

Prompts

Help

Key Features

Leadership wants the 80/20 story: which 20% of products bring in 80% of sales. The chart that tells it — ranked bars with a cumulative percentage line and the vital few coloured apart from the trivial many — is genuinely awkward to build. The threshold colouring needs a DAX pattern that's evaluated per item, or every bar comes out the same colour; the bars have to be sorted at the query level or the line won't climb properly; and the dual Y-axis and combo styling live in undocumented visual properties. This skill generates the whole thing from one command — the measures, the configuration table, and the chart — and it reclassifies live as people slice — run it with /pareto-chart.

How it works

Type /pareto-chart, point it at a chart to turn into a Pareto (or a page to add one), answer two quick questions, and the skill builds everything:

  1. Reads your chart — picks up the dimension to rank, the measure to rank by, and that measure's table straight from the visual

  2. Asks two things — which display folder the measures go in (default _Pareto) and the threshold (80% by default, or 70% / 90% / your own)

  3. Writes the DAX — four measures (cumulative %, the per-bar colour, a dynamic Y-axis ceiling, and a count of items inside the threshold) using the SQLBI WINDOW + RANK pattern, so it recomputes under any slicer

  4. Adds a configuration table — a small Pareto Configuration table holding the threshold, so you can change it later without editing DAX

  5. Builds the chart — a combo chart with bars sorted biggest-first, a smooth cumulative line, the dual Y-axis set up, and items under the threshold in your primary colour (the rest muted)

  6. Matches your page — title font, data labels, and the line colour are read from the visuals already on the page

  7. Converts in place when you point at a chart — it reuses that visual's spot, group, and visibility, and keeps the descending sort correct even after bookmark navigation

What you get

  • A Pareto combo chart — bars ranked biggest-first, a smooth cumulative % line, dual Y-axis, styled to match your page

  • Dynamic threshold colouring — items under the threshold in your primary colour, the rest muted; recolours live as people slice

  • Four DAX measures — cumulative %, per-bar colour, dynamic Y-axis ceiling, and a count of items inside the threshold, grouped in a _Pareto folder

  • A configuration table — a Pareto Configuration table holding the threshold, editable any time without touching DAX

Tool Information

Skill

39 USD

Bundle (All skills)

249 USD

Category

DAX

Version

Version 3.2.2.2.6

or log in if you already have an account