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 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.