> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/filter-rows.md).
# Filter rows
Use the **Filter Rows** transformation to keep only rows that meet specified conditions.
Filtering rows reduces the amount of data in a query and ensures that only relevant records are available for analysis and reporting.
### Filter rows
The following example filters a query to keep only rows where **Country** is **United States of America** and **Sum of COGS** is greater than **500250**.
1. On the **Transform** tab, select **Filter Rows**.
\
The **Filter Rows** dialog opens.
2. Enter the following example filters. For a full list of filter options, see Filter dialog options later in the article.
1. In **Column Name**, select **Country**.
2. In **Operator**, select **Is**.
3. In **Value**, select **United States of America**.
4. Select **Add Filter**.
5. Select **And**.
6. In **Column Name**, select **Sum of COGS**.
7. In **Operator**, select **Is greater than**.
8. In **Value**, enter **500250**.
3. Select **Apply**.
After you apply the filter, only rows that satisfy the specified conditions remain in the query results.
The applied filter appears in **Performed Steps** and applies to subsequent transformations, calculations, and reporting scenarios.
### Options for filter dialog
The filter dialog supports the following options:
* **Condition**: Defines how to combine multiple filter conditions.
* Use **And** when all conditions must be true.
* Use **Or** when any condition is true.
* **Column Name**: Select the measure or dimension to filter on.
* **Operator**: Select the condition to apply.
* For text columns, operators include **Is**, **Is not**, **In**, and **Not in**.
* For numeric columns, operators include **Is**, **Is not**, **Less than**, **Greater than**, **Less than or equal to**, and **Greater than or equal to**.
* **Value**: Enter a value or select one from the list.
* **Add Filter**: Add more filter conditions.
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://docs.fabricplan.com/planning-sheets/how-tos/infobridge/data-transformations/filter-rows.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
