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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.