+ Reply to Thread
Results 1 to 2 of 2

Date Filter Showing All Dates in the Year

  1. #1
    Registered User
    Join Date
    09-26-2019
    Location
    Baton Rouge
    MS-Off Ver
    365
    Posts
    1

    Date Filter Showing All Dates in the Year

    I have two identically constructed Pivot Tables feeding two different Pivot charts. The source data is the same. I added date filters to both Pivot Tables. When I click the Date Filter in one Pivot Table I get the first screen grab and the other Pivot Table gives me the second screen grab. Why would one Pivot Table show all the dates in the year when there are only 14 dates in the source data?

    Screen grab 1.png

    Screen grab 2.png

    Screen grab 3.png
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,532

    Re: Date Filter Showing All Dates in the Year

    Hello USAFMAJ(RET) and Welcome to Excel Forum.
    Thank You for your service.
    If the desired end result is to have the charts both similarly filtered by only the fourteen dates in the source data then I suspect you could link both charts to the pivot table that displays that Date Filter as opposed to using two pivot tables.
    If you need assistance please upload the file, including source data, from which the screen shots were made.
    To upload an .xlsx file click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Replies: 4
    Last Post: 07-30-2020, 11:39 PM
  2. [SOLVED] Date filter not showing all dates
    By ManuMFK in forum Excel General
    Replies: 25
    Last Post: 09-26-2017, 12:12 AM
  3. Replies: 3
    Last Post: 10-06-2015, 05:30 PM
  4. Replies: 1
    Last Post: 04-22-2015, 08:08 AM
  5. [SOLVED] 1900 year date when filter column of dates
    By rz6657 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-03-2013, 12:18 PM
  6. Replies: 2
    Last Post: 01-28-2013, 06:05 PM
  7. Replies: 3
    Last Post: 08-14-2012, 05:14 AM

Tags for this Thread

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