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