Pareto Chart

80/20 Analysis Chart

DAX

Featured Image

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:

  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 — Pareto Cumulated %, Pareto CF (color), Pareto Y Axis Max, # Pareto Items

  4. Creates a lineStackedColumnComboChart on the target page — columns sorted descending, smooth cumulative % line rising from ~0% to 100%, bars colored by threshold position

  5. Configures dual Y-axes: primary driven by Pareto Y Axis Max, secondary fixed at 0–1.2

  6. Patches model.tmdl with the required ref table 'Pareto Configuration' entry

What you get

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

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

  • Combo chartlineStackedColumnComboChart with bars sorted descending, smooth line, dual-axis scale

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

Tool Information

Price

20 USD

Category

DAX

Version