Unwanted Date Group filters less than (<date) greater than (>date) RRS feed

  • Question

  • When grouping by dates in pivot table, unwanted group filters with dates less than and greater than show up in report filters including slicers. Ex <1/1/2018 and greater than 12/31/2019. Data in pivot table does not have any dates less than 1/1/2018 or data greater than 12/31/2019. Unable to delete these filters. Appreciate someone from Microsoft answering this question as question has been posted before in community with absolutely no correct answer. 
    Monday, November 4, 2019 5:32 PM

All replies