Text Area (AND/OR Support)

The Text Area view type in facet filter provides an efficient way to filter data dynamically using text inputs with AND/OR conditions. This enhances user experience by offering precise control over category-based filtering in the Super Filter visual.

Steps to Configure and Use Text Area

1. Add Data to the Category Section

• Add the Super Filter visual into the Power BI canvas.

• Drag and drop the required field into the Category section. This field represents the different facets (categories) users will filter by.

2. Configure the Text Area View Type

• Open the Format Pane and locate the Facet Filter settings.

• Under View Type, select Text Area.

3. Enter Filter Conditions

• A text box will appear, allowing users to type the items they want to filter.

• The number of text boxes will correspond to the number of categories added to the Category section.

• Users can type any value and press enter, and if it matches the data, it will be selected automatically. Users can also use wildcard search to provide multiple search criteria.

4. Apply AND/OR Conditions

• By default, OR is selected for each category. Click the OR option to switch to AND, and click again to revert to OR.

5. Customize Styling Options

• Gap: Adjust the spacing between each category item using the Gap option. This helps in aligning the category boxes in both horizontal and vertical layouts.

• Height: This option is available when the Layout is set to Horizontal View. Configure the Height setting to ensure a consistent dropdown height for all categories.

Image 1: Text Area view with AND/OR operators in Facet Filter

Understanding AND/OR Conditions

The AND/OR operators allow users to apply logical conditions across multiple categories:

• AND Condition: Filters data that meets all the provided criteria for that Category/Dimension. Only records that match all specified conditions will be displayed.

• OR Condition: Filters data that meets at least one of the provided criteria for that Category/Dimension. Records that match any of the specified conditions will be displayed.

Example

• If the user tags Bikes, Components in the Category field and chooses OR, then the filter will return items that are either Bikes or Components.

• If the user tags Silver, *B* in the Color field and chooses AND, then the filter will return all items that contain both Silver and the letter B in the Color record. In this case, records containing values like "Silver/Black" are filtered.