Report filter conditions

Different types of filter conditions can be defined for the distinct filter scopes. For example, report and page-level filters are limited to relatively simple filter conditions that reference individual columns of a dataset. However, more complex and powerful conditions such as filtering by the results of a DAX measure and top N filters can be applied via visual level filters.

The following outline and matrix (filter conditions by filter scope) summarize the filtering functionality supported:

  • Basic Filtering:
    • A single equality condition for a column to a single value or set of values, such as "is North America or Europe"
    • A single inequality condition for a column to a single value or set of values, such as "is ...

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.