BI Portal Designer - Queries > Create a Query > Create Queries – Filters
  PPT
Create Queries – Filters
 
There are 4 filter types:
Edit
Column
Value
Parameter
We want to filter based on Value for our example. Then, we use the drop-down list to select IN.
The Effective Current Fin Year column has four possible values: Current, No, Previous and <blank>. Highlight the desired value (Current in this example), and press <Enter>.
It is possible to select multiple values.