Where is the Top 10 Filter?

May 18, 2023 - by Bill Jelen

Problem: All of the Power BI Desktop features are shiny, new, and cool. Why can't I find the Top 10 filter so I show only the Top 5 customers in the bubble chart?

Strategy: The top 10 is not built in! However, you can add a measure that calculates the rank of each customer using the RANKX function in DAX. You can then filter your visualization where Rank is less than or equal to five.

The panel on the right offers filters for a single visualization, all visualizations on a page, or all visualizations in a report.

The Filters panel offers three types of filters:
Visual Level
Page Level
Report Level — Figure 1122. Choose your filters at the correct level.

This article is an excerpt from Power Excel With MrExcel

Title photo by Rinck Content Studio on Unsplash