Top N visual-level filters

In the following example, a table visual is filtered based on the top five products for the Internet Net Sales (PYTD) measure:

Top N visual-level filter

For this visual, the prior year-to-date (PYTD) measure used for the filter condition is not one of the three measures displayed. Nonetheless, the following Top N condition filters out all products, including the top-selling product for the current year, that weren't one of the top five products in the prior year:

Top N filter condition

With a Top N filter defined ...

Get Mastering Microsoft Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.