Dual Axis Bar & Column Chart

Dual Axis Bar & Column Chart enables you to plot two measures with different scales side by side on independent axes within a single visual. A single toggle switches between horizontal bar and vertical column orientations, making it straightforward to compare values such as Revenue vs Units Sold, Sales vs Quantity, or Budget vs Actual across categories.

The visual provides small multiples for trellis layouts, conditional colour formatting driven by rules and field values, bar patterns for accessibility, overlapping and lipstick bar layouts via bar offset, and dual reference lines. Full Power BI interactivity is built in — cross-filtering, drill-down, drill-through, report page tooltips, and context menus all work natively.

Key Capabilities

Dual Independent Axes — Plot two measures on separate scales with full support for both horizontal bar and vertical column orientations, switchable via a single toggle.

Small Multiples & Conditional Formatting — Split data into a trellis grid by any category field, and apply conditional colour formatting through numeric rules or field-value mapping.

Bar Patterns & Overlapping Layouts — Apply dot, line, crosshatch, or diagonal patterns to either bar series for accessibility, and use bar offset to create overlapping, lipstick, or thermometer chart layouts.

Full Power BI Interactivity — Cross-filtering, native drill-down and drill-through, report page tooltips and right-click context menus.

Data Labels & Reference Lines — Display formatted data labels with font control, display units, decimal places, and orientation options alongside dual reference lines with configurable colour, thickness, style, and opacity.

Coming Soon

Upcoming releases will introduce axis type selection including logarithmic and linear scale options, advanced multi-level sorting capabilities, and error bars for statistical analysis.