How to Sync X-Axis Scroll Bars across 2 Charts that share the same X-Axis Field?

[JohnJoe123]

Hi Everyone,

A Link to my Power BI File can be found here:

https://drive.google.com/file/d/1LQlIHWVL646E2uULvVH3gu2YH8D__OK9/view?usp=drive_link

I work in a Factory that makes Microchips.

We manufacture these Microchips on one Machine called 'ISP'.

Sometimes, when this Machine is processing the Microchips, it Logs a Fault or 'Error Code'.

I'm currently working a Project that examines Statistics for the ISP Machine for each Calendar Date - i.e. on 1st March 2024, 2nd March 2024 etc.

The 2 Parameters that I am looking at are:

- Running Time of the ISP Machine on each Date (in Minutes)

- How Many Error Codes Occur on Each Date

I have one Query in my Power Desktop File that contains all the Information that I need.

I currently have 2 Graphs on the same Tab in my Power Bi file:

- The First Graph is a 'Stacked Column Chart' - it Shows Date (X-Axis) v Machine Running Time (Y-Axis)

- The Second Graph is a 'Line & Clustered Column Chart' - it Shows Date (X-Axis) v Error Count (Y-Axis)

An Image of the 2 Graphs is shown below:

Both graphs share the same X-Axis field.

Both graphs also default to showing the earliest data on the Left-Hand Side of the Graph.

Because there is over a year's worth of Data now - there is too much for either graph to fit all X-Axis values at once - and so a scroll bar is used to scroll towards the right hand side to obtain data for the latest Calendar Dates.

So for example, the Oldest Data is from July 2023 and both graphs are configured to a width that shows about 30 Days worth of data. So if you want to see data for April 2024, you have to drag the scroll bar in either graph to the right-hand-side.

Currently, when I move the X-Axis Scroll Bar in one graph, the other graph is not affected.

I would like the graphs to work such that when the x-axis scroll bar in one graph is moved, that it moves the x-axis scroll bar in the other graph by the same amount and same direction.

So for example, if I was to move the scroll bar in the first graph to December 2023, I'd like the second graph to automatically 'jump' or scroll to that point. In other words - the two graphs x-axes would always be aligned no matter where on the x-axis you scroll for either one.

Is this Possible?

[Uzi2019 · Accepted solution]

Hi @JohnJoe123 

If you want to sync your x axis try to set minimum and max values for x axis in both the graphs. and also y axis.

But auto sync is quite not possible with multiple graphs.

Or you can  try with Small Multiple option 

I hope I answered your question!

[lbendlin]

How about this?

[JohnJoe123]

Hi @lbendlin ,

Thank you for this,

However, I'd like to keep the 2 Graphs separate.

This is because the actual file that I am using looks like the below image:

The Second Graph (the one with a Count of Errors) actually  has another Y-Axis Parameter known as MTBF (Mean Time Between Failures). So there is no room for another Y-Axis here for Machine Run Time. (The Reason I did not state this in my Original Post is because I wanted to keep it Simple)

Is there a way to Sync the X-Axis Scroll Bars across the 2 Separate Graphs?

[lbendlin]

Try Small Multiples.

[JohnJoe123]

What do you mean?