Power BI filters are useful tools for organizing data, visualizing and comparing your data visualizations, and creating reports. They are utilized to sort data according to a chosen condition.

Filter Types :

Visual Level Filter   2. Page Level Filter   3. Report Level Filter   4. Drill Through Filter

On the right side of the dashboard, locate the Filter Pane. From there, we may apply all of these filters. (refer to image below)

Now we will see each filter types in detail like how to apply them and also the type of filtering that can be applied:

    1. Visual Level Filter: 

This Filter is used in sorting single visual for examples card, slicer, bar chart, map and other visuals. Filtering is         done at granular level. Let’s see the steps involved in it with an example:

Step 1: Expand Visualizations, Filters, and Fields panes from the right side.

Step 2: To apply a visual filter, you just have to click a visual which you want filter, for example in the below             image we have click Sunburst visual.

Visual Level Filter for Sunburst visual with fields

Step 3: After that select field by which we want to filter from the Filters pane. Here in below image, we have           chosen ‘Continent’ field and from that ‘Europe’ option and as a result Sunburst visual will filter as per selected         option. (refer to below image)

We can also do multiple selection and also new Data field can be added there.

Sunburst Visual after applying filter of ‘Europe’ from field ‘Continent’

  2. Page Level Filter:  

Page level filter used to apply filters on a single page of a report, applies filters to all the visuals present in that       page.

Step 1- To use page-level filters use the option “Filters on this page” from the Filters pane

Step 2- Drag and drop a field based on which you wish to sort the information on a report page. In image below     we can see that ‘Country’ field is dragged into selection.

And in below image whole page is being filtered by selection ‘France’ and Germany’ from ‘Country’ field, so whole page will show details related to these 2 countries only. Here we can make both single and multiple selection as per the need.

 3. Report Level Filter: 

To apply a filter to the entire report that is to all the pages of a report uniformly, we use report level filters. For applying this filter drag and drop a field from the Fields section into the ‘Filter on all Pages’ section. Let’s start with below examples we have filtered whole report by selections ‘Australia’ and ‘Cannada’ from data field ‘Country’.

As we can now see the Report pages – ‘Orders’ and ‘Custom Visual’ are getting filtered and showing only data related to country Australia and Cannada.

 

 4. Drill Through Filter:

By using this filter, we can focus on specific entities or on a particular field. This filter helps us to get deeper insight of the data we want. For that we first add the fields in drill-through section. We can analyze any part of the data set and also create any number of drill through views.

I will be focusing more on Drill through filter and step by step process of creating it in next blog series. Stay tuned!

 

Till now we have seen types of filters in power bi, now we will look into modes of Filtering:

     1. Basic filtering:   Its very basic form of filtering, which is applicable in all 3 forms of filters. Here simply we can select option by which we want filter and also search the options, like countries names. (Refer to below image)

      2. Advanced filtering:

This filtering is also present in all 3 types of filters we have seen above. In figure we can see how we do advance filtering. It has unique and important role as by this filtering we can find ranges of data by applying some conditions or rules. It provides you with more precise control over what you want to filter out.

Based on the type of columns, advanced filtering capabilities vary. In 2nd image we can see the set of rules or conditions we can apply.

           

 

 

So this was all about Filters in power bi, we also seen types of filtering there. Its very useful feature which helping in sorting our data and make an effective and efficient dashboard.