+ Reply to Thread
Results 1 to 4 of 4

Timeline slicer connection question

  1. #1
    Registered User
    Join Date
    11-03-2010
    Location
    Seattle
    MS-Off Ver
    Excel 2010
    Posts
    9

    Timeline slicer connection question

    Hello,
    I have 5 tables and created 4 pivot tables, labeled 1-4 on the 'Charts' worksheet. Connections have been reported and the timeline slicer works great for pivots 1-2. Pivot 3 won't update with the slicer and pivot 4 is updating with data from wrong period.
    I believe the connections work and are correct, they linked columns don't have duplicate data and have the same data type. I suspect there is an issue with the differences in the number of 'dates' in each table, but am not sure.

    I am not sure what to look for next, and any help would be appreciated. The file is attached, feel free to make any adjustments necessary.

    Thanks,
    Sean
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-16-2014
    Location
    Amsterdam, Nederland
    MS-Off Ver
    Excel 2013
    Posts
    71

    Re: Timeline slicer connection question

    Hi,

    Check this file. I selected the date field in the Pivots 4 and 3.
    Attached Files Attached Files
    Bas

    Any reputation is appreciated.

  3. #3
    Registered User
    Join Date
    11-03-2010
    Location
    Seattle
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Timeline slicer connection question

    Thanks, this looks like it works. You added date to chart 3 and 4? So that would be needed for each additional chart added I'm guessing?
    For chart #4, values disappear for any dates in 2013 and 2014. Any ideas?

    Really appreciate the help.
    Sean

  4. #4
    Registered User
    Join Date
    12-16-2014
    Location
    Amsterdam, Nederland
    MS-Off Ver
    Excel 2013
    Posts
    71

    Re: Timeline slicer connection question

    HI,

    Please check your source data.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Slicer connection issue
    By dougers1 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-05-2015, 08:08 AM
  2. Timeline Slicer showing more months than in data set
    By berkeleyjake in forum Excel General
    Replies: 3
    Last Post: 04-03-2015, 08:12 AM
  3. Answer a question within timeline
    By freeofcost in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2014, 11:27 PM
  4. Timeline Slicer custom fiscal period
    By pinebush in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-16-2014, 10:57 PM
  5. VBA : Updating Pivot Source = Lost Slicer Connection
    By flipsyd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2014, 06:17 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1