Need help: Pivot table from data model cannot use Timeline filter.

Occasional Visitor


I have a problem with Timeline filter for Pivot table.


I have a table and create pivot table with selected "add this data to the Data Model". Excel01.jpg

Then I create Timeline filter for this pivot table.

As show below, pivot table didn't show data in Jan 2022 as I chosen. Also the month of June I chosen, the data didn't show. 

I have tried to create another pivot table without selected "add this data to the Data Model" and create Timeline filter and select Jan 2022. The data shown up on the pivot table. So, I think it's because the date data come from data model and it doesn't recognize as date format.

But the format for the date already is date format.


Could you please advice me how to set the excel setting or any ways to use timeline filter for Pivot table with data from data model?

Thank you very much in advance.  

1 Reply


To my knowledge there is no such setting. Could you please check if attached works in your environment, that's exactly the same sample.