Filters

In Power BI, filters are tools used to control and refine the data displayed in reports and dashboards. These filters allow users to focus on specific subsets of data based on certain criteria.

There are various types of filters in Power BI, including:

1. Visual Filters

Applied to a specific visual or chart to limit the data displayed within that visual.

1. Page Name - Name of the page where the filter is applied.

2. Visual Name - Name of the visual on which the filter is applied.

3. Filter Field - The field used to filter required information.

4. Visual Type - The type of visual on which the filter is applied.

5. Filter Type (Basic/Advanced) - The type of filter that is applied on the visual- Basic ( ) or Advanced ( )

6. Filter Definition - The filter condition applied on the visual

7. Lock Filter? - Displays if the visual filter is locked or not

2. Page Filters

Applied to an entire page in a report, affecting all visuals on that page.

1. Page Name - Name of the page to which the filter is applied.

2. Filter Type (Basic/Advanced) - The type of filter that is applied on the visual- Basic ( ) or Advanced ( )

3. Filter Definition - The filter condition applied on the visual

4. Lock Filter? - Displays if the visual filter is locked or not

3. Report Filters

Applied to the entire report, influencing all visuals across all pages.

1. Filter Field - The field used to filter required information.

2. Filter Type (Basic/Advanced) - Type of filter that is applied on the visual- Basic ( ) or Advanced ( )

3. Filter Definition - The filter condition applied on the visual

4. Lock Filter? - Displays if the visual filter is locked or not

4. Drillthrough Filters

Allow users to navigate from one page to another, drilling down into more detailed information.

1. Source Page - The source page on which the visual gets drill through to the target page to get details that are filtered to that context.

2. Target Page - Name of the page that has the visuals you want for the type of entity that you're going to provide drillthrough for.

3. Filter Field - Shows the field used to filter required information.

4. Drillthrough Field - The field for which you want to enable drillthrough.

5. Lock Filter? - Displays if the visual filter is locked or not