Date Filter in Pivot Table generated through Power Pivot

[Indra]

Hi there,

Hope everyone's stay healthy.
Can someone help me how to find the date filter menu in the pivot table generated through power pivot?

Thanks,
Indra

[Indra]

I just found out that I can insert a timeline, but if there is a date filter menu like we have in the usual pivot table would be nice.

Regards,
Indra

[HansV]

As far as I know, it works just like with an ordinary pivot table.
If you add a date field to the Rows or Columns area, the drop-down menu of the field will offer all Date Filters options.
If you add a date field to the Filters area, you can select individual values.