I am not able to desensitize the sheet I'm using as it's just too large and complex and I get mixed results trying a simplified version due to how many update macros the original has (i'm assuming), as sometimes the simplified works despite the original not doing so even when it's a 1:1 copy, and sometimes it doesn't work. I can't place why. The intended function I'm trying to see is basically a dashboard that shows data in a variety of forms from 2 data source tables that you can use to view relevant data by date, department, shift, etc. navigating it with slicers and a timeline object.

The 2 data sources are pasted from downloaded excel files from a 3rd party program and put directly into a dable every week. They are essentially identical, but each is a different type of report sheet that needs to be tracked independently from the other.

The normal slicers are working just fine, but I cannot get the timeline object to successfully filter both. I've tied both data sources in powerpivot (many to one for each relating to a 'calendar' table created in powerpivot), however when I tie the date in the second pivottable to 'calander'(powerpivot) any date range I apply to the timeline just empties the pivottable and it shows -literally- nothing at all. When I tie it to the 1st data source table's date, it does filter, but it doesn't do so correctly so it just shows the total count of all values for every single day of every single month and even the 'grand total' value is equal to that, rather than being the sum of that value multiplied by the number of times it appears which is... strange. It only works if I tie a new timeline to the 2nd pivottable and use that table's own source date, but that doesn't allow me to have the dashboard work how I need it to (change one timeline, see all results).

I tried using VBA to automatically apply the second timeline's filter to the firsts when it's updated, that way I could hide it, but that didn't work/I couldn't figure out how to do it. Then I thought I might be able to apply a filter directly to the datasource table for the 2nd based on the date I apply to the timeline object, bypassing the need for a date filter on the 2nd source, but that also didn't seem to work.

So i'm not sure what i'm doing wrong here.

The relationships in PowerPivot go like this:

Source 1, Date Column: Many to one: PP Calendar, Date Column
Source 1, Name Column: Many to one: FuzzyNameMatch, Common Name Column

Source 2, Date Column: Many to one: PP Calendar, Date Column
Source 2, Name Column: Many to one: FuzzyNameMatch, Common Name Column.

Pivots:
Source 1; Filter= none | Columns: Zone, Shift | Rows: Year, Quarter, Month, Date(from source1 table) | Values: Count of (arbitrary column)

Source 2; Filter=none | Columns: Department, Shift | Rows: Year, Quarter, Month, Date(from source2 table) | Values: Count of (arbitrary column)

On the Dashboard there are filters for zone/department and shift that function properly. There is also the timeline object, and that does successfully filter Source1's pivottable, however it does not successfully filter source2's despite having it checked on in the timeline's connections.

Both date columns in the relevant source data tables are formatted correctly and identically as mm/dd/yyyy hh:mm:ss

The calendar table in powerpivot is untouched from how it was created (automatically via powerpivot create-date-table).

Any assistance here for something I might have overlooked?