Power BI Basic Filters

Power BI Filters are used to restrict the data as per the requirements. For example, we can exclude a product from display, or we can display top / bottom 10 performing records. In this article we will show you, How to create Power BI basic filters with example.

How to use Power BI Basic Filters

To demonstrate the Basic Filters in Power BI, we are going to use the Clustered Column Chart that we created in our earlier post. As you can see from the below screenshot, we used the Country Name as the Axis field, Occupation as Legend field, and Sales amount as the Value field.

Under the Filters section, you can see the list of filters that are available in Power BI

Visual Level Filters: This includes Filters on Dimension, Filters on Measures, Basic Filters, Advanced Filters, and Top N filters
Page Level Filters: Theses Page Level Filters will apply to all the visuals present in the current page.
Drill through Filters: This Drill through Filters helps you to drill through particular region, or particular category etc.
Report Level Filters: Theses Report Level Filters will apply to all the pages that are present in the current Report.

Let me expand the English Country Region Name (in Short Country) to see the filter types.

Use the drop-down list to see the list of filter types available for dimension.

Advanced Filtering: This option help you to use more advanced options like: starts with, ends with, contains etc.
Basic Filters: Used to perform basic operations.
Top N: Used to find top 10 records, or bottom 10 records.

In this example, we want to discuss about the basic filters so, let me select the same.

Selecting Basic Filters will display the rows that are available for this column. You can use the check boxes to select One, None (or All)

Let me select Australia, Germany, United Kingdom, and United States. From the below screenshot you can see that, the clustered column chart is displaying the column that belong to sleeted countries.

Required Single Selection: This will restrict us to select one field at a time. I means, now you can select only one country name at a time.

As you can see, we selected United States

By unchecking the Required Single Selection property, you can select multiple fields.

By clicking that little tiny clear filter button will help you remove the existing filters.

Power BI basic Filters on Multiple dimensions

Let me expand the English Occupation column to apply filters on Occupation.

Let me select Management, Professional, and Skilled Manual fields as the basic filtering values. As you can see from the below screenshot, it is displaying 4 countries that we selected in Countries Filters, and Three occupations that we selected now.