Power pivot timeline slicer not pulling all data

[sabinap16]

Hi there!
I'm having some issues with the timeline slicer for a pivot table. I have created a relationship between several sets of data, with multiple dates. Each set of data corresponds to a specific "Influencer." When sorting dates using the timeline splicer, it correctly pulls information within a specific date range from the "Shipping" sheet, but does not pull corresponding date information from the "Posts sheet." It will calculate the sum of all likes or comments, but when I look for that sum within a specific date range, the values do not change. Could you help me identify the error? The pivot table and slicer I refer to is in the "KPI" sheet. I will post the spreadsheet in the thread. Thank you!

 

[VBA Geek]

hi Sabina, could you link us to your file?

 

[sabinap16]

hi Sabina, could you link us to your file?

Sure, here is a link to the doc. https://www.dropbox.com/s/agw1tb57qcgb7x3/Influencer Doc Example.xlsb?dl=0
The slicer and pivot table are in the "KPI" tab.
Thanks,
Sabina