I need to create a pivot timeline slicer based on calendar an not a column date. The slicer only allows to slice based on start date or end date which does not show correct results. Attached is a screen shot sample. Any ideas on how to resolve issue? The system has Excel 2016 but does not have power pivot.