b.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.

Video 1: Text Area Filter

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.

All types of searches, such as Wildcard, Operator-based, and Autocomplete is supported here.

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.