Back

Pareto Chart

80/20 Analysis Chart

DAX

DAX

pareto-chart

Overview

Features

Prompts

Help

Key Features

Your bar chart shows product revenue, but leadership wants to know which 20% of products drive 80% of sales. The threshold color coding requires a DAX pattern that evaluates per item correctly — using the wrong approach returns the same color for every bar. Building it with the correct ranking pattern, fixing the sort definition in the visual query, configuring the dual Y-axis, and styling the combo chart requires knowledge of undocumented visual definition properties. This skill generates everything in one command — run it with /pareto-chart.

How it works

Type /pareto-chart, provide your dimension and measure, and the skill builds everything:

  1. Scans the model to validate the dimension table, column, and base measure

  2. Creates a Pareto Configuration calculated table with the threshold (default 80%, customizable)

  3. Generates 4 DAX measures — cumulated percentage, color formatting, Y-axis ceiling, and item count within threshold

  4. Creates a combo chart on the target page — columns sorted descending, smooth cumulative percentage line, bars colored by threshold position

  5. Configures dual Y-axes: primary driven by a dynamic ceiling, secondary fixed at 0-1.2

  6. Patches the model definition with the required table registration

What you get

  • Pareto Configuration table — calculated table with threshold row, editable post-deploy

  • 4 DAX measures — cumulated percentage, color formatting, Y-axis ceiling, item count within threshold

  • Combo chart — bars sorted descending, smooth cumulative line, dual-axis scale

  • Dynamic threshold coloring — bars below threshold in primary color, bars above in muted color — updates with slicers

Explore more in this category

abc-classification

ABC Classification

DAX

Classify dimension items (Products, Customers, SKUs) into A/B/C tiers based on any measure

rolling-averages-kit

Rolling Averages Kit

DAX

Add 3-month, 6-month, and 12-month rolling averages plus a running total to any measure in your model

time-intelligence-kit

Time Intelligence Kit

DAX

Generate 23 time intelligence items that apply to every measure in your model automatically

Tool Information

Skill

39 USD

Bundle (All skills)

129 USD

Category

DAX

Version

Version 2.1.1.2.15

Sign up to buy

or log in if you already have an account