Forum Discussion
Timeline Not Matching Other Filters
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" fi...
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
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