Microsoft Power BI Cookbook

Visual interaction control

In this example, the report is required to always display three current year measures while allowing for the filtering of other visuals with date dimension columns. Additionally, the sales for the subcategories of accessories and clothing should be easily accessible.

1. Create a report with three groups of visuals: cards, charts, and slicers.
   • The three cards must only show the current year and thus ignore or override the two slicers

Edit Interactions Report Page

2. Select a visual on the canvas and click on Edit interactions from the Format tab.

3. Select the Calendar Yr-Mo slicer visual, and for each card visual ...