Dumbbell Chart

What it does.

Business analysts often need to highlight the variance between two related values across categories — the gender pay gap across departments, revenue with and without incentives, or pricing before and after discount. Standard bar and line charts struggle to bring out this picture clearly when both values share an axis. Dumbbell Chart places two markers per category on a shared scale, connected by a line that makes the gap immediately visible — turning raw numbers into an intuitive story of change.

The visual recognises currency and percentage formats directly from your data model, so axis and data labels display the correct symbols without manual configuration. Change labels show the difference between the two values as an absolute number, a percentage, or both — with optional directional triangle indicators that instantly communicate whether the movement is positive or negative.

Conditional color formatting highlights categories that meet specific thresholds independently for each marker series, using numeric rules or field-value mapping. Unlimited reference bands mark target zones or acceptable ranges behind the data, and four marker shapes with full styling control ensure accessibility and brand alignment. Small multiples split the chart into a trellis grid for side-by-side comparison across segments, with orientation-aware axis coupling and range matching. Full Power BI interactivity is built in — cross-filtering, drill-down, drill-through, report page tooltips and context menus all work natively.