# Search & filter

When you have a large amount of data, features like search & filter can help you focus on a smaller subset based on certain conditions. You can use the search option to look for specific words or values. Nested AND/OR filtering and column filtering can be applied to filter records based on conditions.

{% embed url="<https://lumel.wistia.com/medias/xf8oguse6v>" %}

> ## **Related resources**
>
> #### Feature highlights
>
> [Excel-like pivot analysis in Power BI](https://inforiver.com/excel-like-pivot-analysis-powerbi/)
>
> #### User guide
>
> [Search & filter](https://docs.inforiver.com/working-with-inforiver/3.-basic-interactions/explore-and-filter-data/search-and-filter)