Question

You are building a report page that shows the relationship between marketing spend and revenue for each product category. Stakeholders want to visually observe how this relationship has changed across each year without adding multiple visuals or a slicer that requires manual clicking. Which approach best meets this requirement?

Accepted Answer

Use a scatter chart and place the Year field in the Play Axis field well

Answer

Use a line chart with Year on the X-axis and add a forecast in the Analytics pane

Answer

Use a clustered column chart and enable the small multiples feature for Year

Answer

Use a scatter chart and add Year as a slicer synced across the page