Power BI Top N Filters are used to display the top performing records, and Bottom N filters are used to display least performing records. For example, we can display top or bottom 10 products by orders or sales. In this article we will show you, How to create Power BI Top 10 Filters and Bottom filters with example.
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 below screenshot, 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
Let me expand the State Province Name (in Short State) to see the filter types. By default, Basic Filters option is selected as the Filter type
Use the drop-down to change it to Top N filters
Following are the list of options that are available for TOP N filters
- Show Items: Top was selected by default. However, you can change this to 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. Top N filter will use this Measure to find Top 10 and Bottom 10 records.
Let me add Sales Amount to By Value section, and 10 to text box
Below report is displaying the Top 10 states according to their Sales Amount. Or we can say, Top ten states based on their sales Amount.
Use the Drop down arrow to minimize the filter
Let me change the value to 5.
As you can see that the filter has selected Top 5 State province names by sales amount
Power BI Bottom 10 Filters
Let me change the Show Items option from Top to Bottom, and leave the integer value to 5
Click Apply Filter button
Below report is displaying the bottom 5 states according to their Sales Amount. Or we can say, Least performing states.
Let me change the integer value to 10
Below report is displaying the bottom 10 states as per their Sales Amount.