Question

A sales report page contains a Region slicer, a clustered column chart of Sales by Product, and a KPI card. When users select a region, the column chart currently dims (cross-highlights) the unselected bars instead of removing them entirely, which confuses stakeholders who want the chart to show only the selected region's products. You need the column chart to be fully filtered by the slicer while leaving the KPI card unaffected. What should you do?

Accepted Answer

In Edit interactions, set the slicer's interaction with the column chart to Filter, and set its interaction with the KPI card to None.

Answer

Add a page-level filter for Region so both the chart and the card respond only to that field.

Answer

In Edit interactions, set the slicer's interaction with the column chart to Highlight and with the KPI card to Filter.

Answer

Turn on Sync slicers for the page so the column chart is filtered and the KPI card is excluded.