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.

NOTE: This is part of the Using PowerPivot to Analyze Your Dynamics AX Data blog series where we show how PowerPivot can assist you with advanced data analysis and reporting, making those extracts from Dynamics AX to Excel even more valuable. If you want to see all of the other posts in this series, click here.

HOW TO DO IT

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.

HOW IT WORKS

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: