Pareto Chart
80/20 Analysis Chart
DAX
Overview
Features
Prompts
Troubleshooting
Key Features
Your bar chart shows product revenue, but leadership wants to know which 20% of products drive 80% of sales. The classic approach places a static cumulative line on a combo chart, but the line only rises monotonically if the sort order is controlled at the query level — not just visual formatting. The threshold color coding (primary color below 80%, muted above) requires a DAX pattern that evaluates per item: CALCULATE(FILTER(...)) strips the item context and returns the same color for every bar. Building it correctly with the SQLBI WINDOW + RANK pattern, fixing the sort definition in the visual query JSON, configuring the dual Y-axis, and styling the combo chart requires knowledge of undocumented visual.json properties. This skill generates everything in one command.
How it works
Type /pareto-chart, provide your dimension and measure, and the skill builds everything:
Scans the model to validate the dimension table, column, and base measure
Creates a
Pareto Configurationcalculated table with the threshold (default 80%, customizable)Generates 4 DAX measures —
Pareto Cumulated %,Pareto CF(color),Pareto Y Axis Max,# Pareto ItemsCreates a
lineStackedColumnComboCharton the target page — columns sorted descending, smooth cumulative % line rising from ~0% to 100%, bars colored by threshold positionConfigures dual Y-axes: primary driven by
Pareto Y Axis Max, secondary fixed at 0–1.2Patches
model.tmdlwith the requiredref table 'Pareto Configuration'entry
What you get
Pareto Configurationtable — calculated table with Threshold row, editable post-deploy4 DAX measures — cumulated %, color formatting, Y-axis ceiling, item count within threshold
Combo chart —
lineStackedColumnComboChartwith bars sorted descending, smooth line, dual-axis scaleDynamic threshold coloring — bars below threshold in primary color, bars above in muted color — updates with slicers
Explore more in this category

ABC Classification
DAX
Classify dimension items (Products, Customers, SKUs) into A/B/C tiers based on any measure, with real-time reclassification when slicers change.

Convert Implicit measures to Explicit
DAX
Replace automatic column aggregations in visuals with proper DAX measures for full control.

Time Intelligence Kit
DAX
Generate 23 time intelligence items that apply to every measure in your model automatically

