Report and page level filters

In this example, report and page level filters are applied to the European Sales and Margin Monthly report. For this report, it's determined that the European team doesn't need to view other sales groups or countries.

Report and page level filters are most commonly implemented at different levels of a dimension hierarchy that is relatively static and with few unique values, such as the example in this recipe. Date range filters should generally be applied either in the data retrieval queries or the report canvas with visuals such as the date slicer. As these filters are applied to all visuals in the report or page, respectively, try to avoid filters against high-cardinality columns such as Product ID or Sales ...

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

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