Timeline Not Matching Other Filters

[silmer]

Hello all,

I tried to find a similar topic discussion on here but have not seen one. I currently have a pivot table with a few sliders and one timeline filter. One of the filters is a "Six Month" filter, which shows items that are due for review within the next 6 months. This filter is from a column on the original table that shows either "Six Months Review" or "Do Not Need to be Reviewed" and is based off a formula of a date column. My issue is, when I click to filter on "Six Months Review", the date timeline doesn't filter on those 6 months, it still shows all the dates present in the table. Is there a way for the Timeline filter to show data based off of the other filters as well? 

Would appreciate any insight at all, thank you!

[#2]

While not a direct solution, using slicers for the "Six Month Review" filter might provide better visual control over the data.

OR
Create a Calculated Field: If your data model supports it, create a calculated field that combines the "Six Month Review" logic with the date. This calculated field can then be used for the Timeline filter.
Create a Measure: In Power Pivot or Data Model, create a measure that calculates the "Six Month Review" items and use this in the PivotTable

OR

Create dynamic named ranges for "Six Month Review" items and all items.
Use these named ranges as data sources for PivotTables.
Update the named ranges based on other filter criteria

[#3]

@silmer 

Timeline works independently of other filters. Moreover, if you have only few months in date field (doesn't matter source or calculated field), for example Dec 2024 and Jan 2025, timeline shows you all dates in both years, from Jan 01, 2024 to Dec 31, 2025.