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 O’Reilly online learning.

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