--- title: "Filter Data in Pigment to Customize Views in Tables, Boards and Charts" slug: "filter-data-pigment" description: "Learn to filter Views in Pigment using Metrics and Dimensions to tailor data for Boards and Charts and improve clarity in your data analysis." tags: ["Chart Filters", "Data Filtering", "Pigment Filters", "Reporting Data Visualization "] updated: 2025-10-13T16:22:43Z published: 2025-10-13T16:22:43Z --- > ## Documentation Index > Fetch the complete documentation index at: https://kb.pigment.com/llms.txt > Use this file to discover all available pages before exploring further. # Filter Data in Pigment You can apply filters to Tables and Metrics in Pigment to tailor Views for use in Boards and Charts. This article describes how to use filters effectively. ## How to Filter in Pigment From within either a Metric or Table, select the **Filter** icon and select **+ Add a Filter**. When you’re done creating filters, the number of applied filters is visible next to this icon. ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/8b9480ad-efb1-4fc1-b3d4-bb8ba1cd30ab.png) Add a filter in a Metric or Table When you select **+ Add a filter,** you have the option to: - Select a Metric, and then filter the underlying Dimensions by the Metric value - Select a specific Dimension and directly filter its Items or filter its Items based on one of its Properties ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/e7f45239-4a81-4b45-8f16-0e98dbb32fe6.png) Filter Panel in Pigment ### Filter by Metric When you select a Metric from the **Add a filter** menu, this filters Items belonging to the most granular underlying Dimension in the View, depending on the cell values for that Metric. The options for filtering by Metric depend on your Pivot configuration: - the filtered Dimensions are automatically inferred from the grid configuration - filters are applied to the most granular Dimensions that are closest to the View You can also right-select a specific grid header to create a filter that’s based on a Metric. Each new filter you add using this method creates a separate rule in the filter panel. If you use this shortcut in Tree mode in Views, filtering is applied to the closest Dimension to the grid. For this reason, we recommend that you expand the Tree mode before filtering. When multiple Metrics are available for filtering on Tables, you need to choose just one Metric. ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/c05be48e-957c-48d7-92c1-36cddb88474a.png) Filter by Metric ### Filter Dimension-type Metrics with Variables In Pigment, when filtering Dimension-type Metric data, you can use a Variable to filter between that Dimension’s Items. This is particularly useful if you want to allow Members to filter these Items directly from the Board. You can also filter by Dimension Property, where the Property is of type Dimension. To apply this type of filter, do the following: 1. Create a Variable on the required Dimension on your Metric. See guidance [here](/v1/docs/use-item-variables#how-to-create-and-update-variables). 2. (*Optional*) If you want users to dynamically choose which Items should be filtered, then enable the option that allows Members to change Variable values in their session. When you enable this option, the Dimension Item values are displayed in a separate menu next to the Page Selector wherever your Metric is used. ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/f80595af-5f08-4c80-b9c4-b391f2413b96.png) 3. In your Metric, open the Filter panel and create a new filter. 4. Select the new Variable from the menu, and select **Apply**. ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/99596299-e8d6-4df8-a224-ef9e2d61e029.png) The Dimension Items on which you can filter are available as a selector beside the Page Selectors. This selector's options can be customized almost in the same way as any Page Selector option. For more information, see [Use Page Selectors to Customize Context in Views and Boards](/v1/docs/use-selectors-context-views-boards). ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/14a0b7fa-dd6f-485b-b6eb-c8c96c7cba6b.gif) Filterable Dimension Items appear next to Page Selectors ### Filter by Dimension When you select a Dimension from the **Add a filter** menu, you can apply a filter based on that Dimension’s Items. Only Dimensions in Rows or Columns can be filtered. After you choose the Dimension you want to filter, you can filter by directly selecting the Items. - If you select **is in**, it only shows those Items. For example, if a filter is set to **Filter Product where Items is in Product A***,* then the result is that only Product A is shown. - If you select **is not in**, it only removes those Items. For example, if a filter is set to **Filter Product where Items is not in Product A***,* then the result is that only Product A is the only item not present. When choosing these options it's important to think of the future of the list. If you use the Exclude option, all new Items will be shown. ### Filter by Dimension Property When you select a Dimension Property from the Add a filter menu, you can filter a Dimension based on values stored within that Dimension’s Properties. Depending on the Property data type, you will get different options on the type of rule you can set it. **Eligible Dimensions for Filtering** In this example, you can select the Metric value for the Month or the Scenario Dimension. These are considered the most granular Dimensions within a View. ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/0d5591cb-c5ce-4220-993e-9a640f6c7123.png) **Use Operators in Filters** After you choose which Dimension you want to filter, you need to choose an operator such as equals (=), less than (<) or greater than (>), and then you need to enter a value on which to base those operators. These are dependent on the Item type. For example, operators such as `Contains` exist for Metrics that are Text data types. ## Understand rules in filters When adding multiple rules to a filter, you must set how the rules interact with each other, the options are `OR` and `AND`. The `AND` operator means that all conditions must be met for the rule to be true. For example, if you have two rules: - Rule A: The sky is blue - Rule B: It is daytime An `AND` combination would only be true if both Rule A and Rule B are true - that is, if the sky is blue and it is daytime. On the other hand, the `OR` operator means that only one of the conditions needs to be met for the rule to be true. Using the same rules as before, an `OR` combination would be true if: - Rule A is true (the sky is blue) - Rule B is true (it is daytime) - Both are true In summary, `AND` requires all conditions to be satisfied, while `OR` requires at least one condition to be satisfied. When setting up multiple rules, you can only use one of these options for the entire filter. This means all rules will be set to the condition of `OR` or `AND`. ## Combine filtering and sorting to see top and bottom brackets You can filter Items by Metric values such as Integer, number, or dates. Choose to filter Items in either the top or bottom categories by specifying the size of the category and whether it should include the highest or lowest values. When filtering with Metric values that are integers, numbers, or dates, you can choose to filter Items in either the highest or lowest value brackets. You can do this by defining the size of the value bracket, and if it should be in the highest or lowest values. 1. Select the Metric value. 2. Use the operators menu to select either `is in the top` or `is in the bottom` . 3. Enter a number to define the size of the bracket. For example, if you wanted to see your top 5, you select `is in the top` and then enter 5. When the filter is activated, it also activates the Sort functionality. The Sort’s location is determined by the choice of either Top or Bottom. This filtering option ignores blank values. ## Identify Item specifics from opposite Dimensions When using a Metric value, you must identify the specific Items from the Dimensions opposite to the filtered Dimension. This means if your filtered Dimension is in Rows, you have to show the specifics for the Dimensions in the Columns and vice versa. The position of these is determined by the Pivot panel. In this example, the **Country** Dimension is in Rows, the **Year** and **Month** Dimensions are in Columns. If you want to filter multiple Items from opposite Dimensions, you can create multiple filters. ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/3ee18b08-214b-42a0-8662-bf07db1d5b2b.png) Filtering with Opposite Dimensions ## Hide empty rows or columns When working with Metrics or Tables, you can hide empty columns or rows if they have no data. From within the filter, select **Show empty rows and columns** to see multiple options. You can hide empty rows or columns, either separately or together, to make your data easier to find. ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/6f60d07b-8383-4e9d-9cda-184046ddff8e.gif) Hiding Empty Rows or Columns ## Learn more - [Practical Examples and Best Practises for Changeable Static Variables](/v1/docs/practical-examples-and-best-practices-for-changeable-static-variables).