how do i remove this from my filter in pivot table

%3CLINGO-SUB%20id%3D%22lingo-sub-2041995%22%20slang%3D%22es-ES%22%3Ehow%20do%20i%20remove%20this%20from%20my%20filter%20in%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2041995%22%20slang%3D%22es-ES%22%3E%3CDIV%3E%3CDIV%20class%3D%22tw-menu%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22Excel.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244810i7A2A8406CA07D28F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Excel.png%22%20alt%3D%22Excel.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22QmZWSe%22%3E%3CDIV%20class%3D%22DHcWmd%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22oSioSc%22%3E%3CDIV%3E%3CDIV%20class%3D%22g9WsWb%22%3E%3CDIV%20class%3D%22tw-ta-container%20hide-focus-ring%20tw-nfl%22%3E%3CPRE%3E%3CSPAN%3EGood%20afternoon%2C%20I'm%20trying%20to%20filter%20the%20data%20and%20these%202%20dates%20appear%2C%20at%20the%20beginning%20and%20end%20...%20someone%20knows%20how%20to%20remove%20them.%0A%0AThank%20you%2C%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2041995%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2042696%22%20slang%3D%22en-US%22%3ERe%3A%20how%20do%20i%20remove%20this%20from%20my%20filter%20in%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2042696%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F921774%22%20target%3D%22_blank%22%3E%40BARBAS1095%3C%2FA%3E%26nbsp%3BExcel%20has%20grouped%20the%20dates%20in%20your%20data%20by%20year.%20The%20first%20and%20last%20items%20in%20the%20filter%20list%20show%20the%20first%20and%20last%20(%2B1%20day)%20dates%20in%20your%20data%20set%2C%20indicating%20that%20you%20are%20looking%20at%20grouped%20dates.%20Select%20only%20the%20first%20or%20last%20item%20and%20your%20pivot%20table%20will%20come%20up%20blank%2C%20indicating%20that%20there%20is%20nothing%20before%20or%20after%20these%20dates.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Excel.png
 
Good afternoon, I'm trying to filter the data and these 2 dates appear, at the beginning and end ... someone knows how to remove them.

Thank you,

2 Replies

@BARBAS1095 Excel has grouped the dates in your data by year. The first and last items in the filter list show the first and last (+1 day) dates in your data set, indicating that you are looking at grouped dates. Select only the first or last item and your pivot table will come up blank, indicating that there is nothing before or after these dates.

@BARBAS1095 

Bit another behavior will be if add data to data model creating PivotTable.