Applying Filters to your PowerPivot Data Model

Within the PowerPivot Data Model editor, you can also filter the data that is returned to Excel through the filtering option.


To can add a filter to a table in your data model, follow these steps:

  1. Select the drop down from the heading of the field that you want to filter on and you can either manually select the field values to filter on, or you can click on the Filters options to create a rule.
  2. If you create a filter rule then you will be able to update the filter conditions through the Custom Filter dialog box.


After applying the filter you will only see the data that matches.

Check out comprehensive instructor-led Advanced Excel Reporting, Data Modeling ; Analytics with Microsoft Excel Power Pivot here

Happy Excelling
Team Excelgoodies

Leave a Reply

Your email address will not be published. Required fields are marked *