Sync X Axes

Shared Horizontal Axis Scale

Format

Format

sync-x-axis

Overview

Features

Prompts

Help

Key Features

Put bar charts side by side and Power BI scales each horizontal axis on its own. A long bar in the first chart can stand for a smaller number than a shorter bar in the second — so the comparison your reader makes by eye is wrong. Scatter and bubble charts have the same trap: each picks its own left-to-right range, so the dots sit in places you can't compare across charts. The fix is to give every chart the same left and right limit, and to keep that range moving as slicers change so it never clips the data.

Doing it by hand means writing a pair of min/max measures, getting the spacing right so data labels aren't cut off, then setting the axis minimum and maximum on every chart one at a time — and redoing it whenever you add another chart. This skill builds the shared range and points every chart at it in one command — run it with /sync-x-axes.

How it works

Type /sync-x-axes, pick the charts you want on the same scale, and the skill does the rest:

  1. Reads each chart — finds the measure on the horizontal axis and works out the right axis for each type (horizontal bar charts vs scatter/bubble)

  2. Builds one shared range — creates a matching min and max that look across all the selected charts, with a little headroom so data labels aren't clipped

  3. Points every chart at it — sets each chart's axis minimum and maximum to the shared range

  4. Keeps it live — the range moves with your slicers, so the charts stay comparable as filters change

What you get

  • One shared min/max pair — for the horizontal axis the charts share

  • Every chart on the same scale — each selected chart reads its left and right limits from the shared range

  • Room for data labels — a little headroom by default (10% below, 20% above), adjustable to taste

Tool Information

Skill

39 USD

Bundle (All skills)

129 USD

Category

Format

Version

Version 2.2.2.2

or log in if you already have an account