When using a pivot table filter, How can I eliminate time from my date filter?

Richard Kopnyicky 1 Reputation point

I am trying to present my data in a pivot table, for which I have added a filter option for the dates, so that I can select specifically which dates to display in the Pivot table.

my issue is that the time is also apart of the dates in the filter, even though I have removed it from anywhere else. How can I remove the times from my filter list?


Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,520 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Erin Ding-MSFT 4,436 Reputation points

    @Richard Kopnyicky

    Could you tell me what kind of data source did you use and how did you create the connection?

    Please open the data source, in Data, click From Table/Range.
    Then give a screenshot like below.

    You could set the format in Power Query Editor. Click the icon in the upper left corner then click Date.

    After setting the formatting, click Close & Load To…, in the Import Data box, select PivotTable Report and then click OK.

    Then you will see the times removed.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.