Graph Dates

[ljmarstin]

I have a data source that contains a column of dates. There are multiple pivot tables built off the data source all utilizing the same date column to support a dashboard using slicers. On the dashboard there is a date range slicer which displays the selected range of dates and the support data associated with the filters. All of my graphs are displaying the information in the appropriate chronological order for dates except for one. It is displaying the dates as follows once I move the slider into the month of December the date range is from 11/5 to 12/15, the graph will start with 11/10 versus 11/5. It is putting them in the ascending order versus chronological order. If I use the month of November and before it is displaying correctly I have reformatted, removed and reinserted the dates, manually sorted them in the correct order, but as soon as you go in and move the date range slider, it resets the dates. None of the other graphs are displaying the data incorrectly just one. I can't upload the workbook as my company has blocked uploading to this forum. Any help would be appreciated. It is kicking my tail!!!!

I could possibly attempt to email some screenshots to anyone willing to see if they can help me out. Appreciate your time in helping resolve this matter.

[dflak]

Just as a test, create a pivot table with just the dates and control it with the same slider. Do you get the same results?

If you get the correct results, you can overlay the results with a named dynamic range, use the MATCH command to evaluate if the date in the raw data is within this range, and filter the data where this column is true.