Question

You are building a sales report page that must show either a clustered column chart or a matrix in the same screen area, letting users switch between them with a button. Both visuals already exist and are stacked in the same location. You want the button to hide one visual and show the other without navigating to a different page. What is the most reliable way to configure this toggle?

Accepted Answer

Create two bookmarks that each set the desired Selection pane visibility (one visual shown, the other hidden), uncheck Data in each bookmark, and assign one bookmark to a button's Action.

Answer

Use a single bookmark with Data enabled so the button also applies the current filter state when swapping visuals.

Answer

Add a page-level drillthrough filter and point the button's Action type to Drillthrough so the visuals alternate.

Answer

Sync a slicer across the two visuals and let the slicer selection determine which visual is displayed.