Forum Discussion
Pivot Table Default Filter
Found an old thread with https://support.office.com/en-us/article/Set-PivotTable-default-layout-options-efd8569c-f07a-43c1-9db2-4f2912a0f94e showing setting defaults for Pivot Tables, but after a sh...
I'd add data to data model and use DAX measures in PivotTables instead of implicit aggregations.
English? Example? Consider me new to Pivot Tables. I'm editing tables that were in place before I started.
Afraid that won't work then. If you already use cached PivotTables you can't convert them, need to build new PivotTables adding data to data model (check box at bottom left when you create PivotTable). DAX basics are described here QuickStart: Learn DAX Basics in 30 Minutes (microsoft.com) but that's definitely not what you may copy/paste with small adjustments.
As for the cached PivotTable I don't know how to predefine filters before filtered data is added, sorry.
