Power Pivot - filter in the data model does not apply itself into the pivot table

We may need to see the workbook for this.

The filters you're applying in the PowerPivot window only affect what is displayed, in the Power Pivot window. They don't affect what data is returned to the Data Model.

Originally Posted by Microsoft

From https://support.office.com/en-us/art...a-f4c823b96b5e

Filters that reduce the amount of imported data are applied only during import operations. You can’t add filters after the data is already imported and then refresh to get smaller rowsets.

Filters that control which data is displayed in Excel or in Power Pivot are easily applied at any time. Notice that filtering an existing dataset doesn’t change the data that’s in the workbook—just the data that’s displayed. So if file size is a concern, filtering the data as you import results in a smaller workbook.

In your example case, instead of loading your data directly into PowerPivot from the table, use PowerQuery to apply the filters you want, and then Load To Data Model:

Please Login or Register  to view this content.