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
  1. Select a visual on the canvas and click on Edit interactions from the Format tab.
  1. Select the Calendar Yr-Mo slicer visual, and for each card visual ...

Get Microsoft Power BI Cookbook 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.