Filter in pivot table

%3CLINGO-SUB%20id%3D%22lingo-sub-2316274%22%20slang%3D%22en-US%22%3EFilter%20in%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2316274%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewanted%20to%20ask%2C%20why%20the%20date%20filter%20in%20pivot%20table%20show%20dates%20that%20are%20greater%20than%20certain%20date%2C%20how%20to%20hide%20it%20as%20i%20dont%20have%20data%20in%20that%20date%3F%20its%20possible%20in%20slicers%2C%20but%20am%20not%20able%20to%20hide%20it%20in%20filter%3C%2FP%3E%3CP%3Eis%20it%20a%20bug%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22pivot%20table%20date%20filter.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277439i688AC7845104A8D6%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22pivot%20table%20date%20filter.png%22%20alt%3D%22pivot%20table%20date%20filter.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2316274%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Hello all

 

wanted to ask, why the date filter in pivot table show dates that are greater than certain date, how to hide it as i dont have data in that date? its possible in slicers, but am not able to hide it in filter

is it a bug?

pivot table date filter.png

0 Replies