Power pivot timeline slicer not pulling all data

sabinap16

New Member
Joined
Oct 16, 2018
Messages
2
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!
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Forum statistics

Threads
1,213,504
Messages
6,114,020
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top