my problem is the following: I have a data table with the date column that takes 3 days, they are 1, 11 and 21. When I create a pivot table and apply filters by dates, they come out every day from 1 to 30 / 31) I just want to filter according to the days data I have.
the following image shows the original date of my data
I need to filter, for example, from January 1 to February 11 and for the filter to apply from 1999 to 2020, which is the year up to which my information is available.
you can try adding data segmentation
parse pivot table-->insert slicer.