Power BI Top 10 Filters

Power BI Top N Filters are useful to display the top performing records, and Bottom N filters are helpful to display the least performing records. For example, we can display top or bottom 10 products by orders or sales. Let me show you how to create Power BI Top 10 Filters and Bottom filters with examples.

How to use Power BI Top 10 Filters

To demonstrate the Top N Filters in Power BI, we are going to use the Bar Chart that we created in our earlier post. As you can see from the screenshot Power BI below, we used the State Province Name as the Axis field, Sales amount as the Value field, and Order Quantity as Color saturation.

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

Power BI Top 10 Filters 2

Let me expand the State Province Name (in Short State) to see the filter types. By default, the Basic Filters option is selected as the Filter type.

Power BI Top 10 Filters 3

Power BI Top 10 Filters

In order to enable Power BI top 10 filters, use the drop-down to change it to Top N filters

Power BI Top 10 Filters 4

The following are the list of options that are available for Power BI TOP 10 filters

  • Show Items: Top filter selected by default. However, you can change this to the Bottom by clicking the down arrow.
  • Empty Text box: Please specify any integer value — for example, 10 means, top 10 records.
  • By Value: You have to drag and drop the required Measure value present in the Fields. The top N filter uses this Measure to find the Top 10 and Bottom 10 records.
Power BI Top 10 Filters 5

Let me add Sales Amount to the By Value section, and 10 to the text box. The below Power BI report displays the Top 10 states according to their Sales Amount. Or we can say, Top ten states based on their sales amount.

Power BI Top 10 Filters 7

Use the Dropdown arrow to minimize the filter

Power BI Top 10 Filters 8

Let me change the value to 5. It means, the Power BI Top 5 filter

Power BI Top 10 Filters 9

As you can see the Power BI filter has selected the Top 5 State province names by sales amount

Power BI Top 10 Filters 10

Power BI Bottom 10 Filters

In order to apply Power BI bottom 10 filters, let me change the Show Items option from Top to Bottom, and leave the integer value to 5

Power BI Top 10 Filters 11

Click the Apply Filter button

Power BI Top 10 Filters 12

The following Power BI report displays the bottom 5 states as per their Sales Amount. Or we can say, Least performing states.

Power BI Top 10 Filters 13

Let me change the integer value to 10

Power BI Top 10 Filters 14

The below report displays the Power BI bottom 10 states as per their Sales Amount.

Power BI Top 10 Filters 15

The following are the remaining types of Filters with a practical example.

  1. Slicer
  2. Basic Filters
  3. Filters on Measures
  4. Page-Level Filters
  5. Report Level Filters
  6. Drill through Filters