Share via

Filtering date hierarchy in pivot table

Anonymous
2022-08-10T15:29:25+00:00

Hi

If I have a calendar table used in a pivot, and only want to see two months for example is there a way to filter it down,

so I just want November and December,

Richard

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Lz._ 38,106 Reputation points Volunteer Moderator
    2022-08-10T20:41:19+00:00

    Richard,

    OK, Power Pivot is involved. Don't use the Date Hierarchy but the Year & Month in the More Fields section.

    Drop them to Rows, then filter Month as you want (Jan-Mar below):

    Your updated file is available here

    1 person found this answer helpful.
    0 comments

6 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-08-11T13:46:32+00:00

    Thanks, never know which to use, only just found the little drop down to the side of a date field in power bi that allows you to change the default to an actual date (01/01/2020 ) .

    Richard.

    0 comments
  2. Lz._ 38,106 Reputation points Volunteer Moderator
    2022-08-11T15:11:16+00:00

    Glad I could help Richard

    0 comments