Question

You are designing a Power BI report where the sales director wants a single button that, when clicked, changes the main visual from a clustered column chart showing sales by month to a matrix showing sales by product category — without navigating to a different page. You have already created both visuals and stacked them in the same location. What is the most efficient way to make the button toggle between the two visuals?

Accepted Answer

Create two bookmarks (each with one visual hidden via the Selection pane), disable Data in both bookmarks, and assign a bookmark to a button plus use a bookmark navigator or a second button

Answer

Configure a drillthrough page for the matrix and add a drillthrough button that passes the month filter context

Answer

Add a field parameter containing both the Month and Product Category fields and bind it to a single visual's axis

Answer

Use Edit interactions to make the button cross-filter the column chart so the matrix appears