Splicer works with all charts but one

Hi Everyone,

I am hoping this is a simple fix and something I am overlooking. I have a workbook with a dashboard reading from a number of different pivots.

All charts read from one data source but one.

I have a splicer which causes all charts to update but the one that is connected to the different data source, even thou its the same variable.

Is there a way I can also get this chart to refresh based on the variable in the splicer?

I have attached the file, all dashboard charts can be found on the Pivots Tab.

Any help or advice you could offer would be greatly appreciated!

Cheers,
Charlie

Hi, you can of course do this using Power Query (I combine two different data sources), I did it manually and all pivot tables are based on new source.