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.

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.

Understanding AND/OR Conditions

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

AND Condition: Filters data that meets all selected criteria. Only records that match all specified conditions will be displayed.
OR Condition: Filters data that meets at least one of the selected criteria. Records that match any of the specified conditions will be displayed.

Example

If the user selects Accessories in the category field and chooses AND, then selects Black in the color field, the filter will return items that are both Accessories and Black in color.
If the user selects Accessories in the category field and chooses OR, then selects Black in the color field, the filter will return all items that are either Accessories or Black in color.

PreviousImage Filter NextEdit Data

Last updated 1 month ago

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.

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.

Understanding AND/OR Conditions

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

AND Condition: Filters data that meets all selected criteria. Only records that match all specified conditions will be displayed.

OR Condition: Filters data that meets at least one of the selected criteria. Records that match any of the specified conditions will be displayed.

Example

If the user selects Accessories in the category field and chooses AND, then selects Black in the color field, the filter will return items that are both Accessories and Black in color.

If the user selects Accessories in the category field and chooses OR, then selects Black in the color field, the filter will return all items that are either Accessories or Black in color.