Change chart based on another graph's selection

Question

I have a report where the user can select from a list of products they want to review and the data is displayed on a separate page. On this page it will have the Total Sales (on the left) for the time frame selected. On the right I want Chart B to be the default chart comparing both Product 1 and Product 2 over time as shown. I want the chart to switch to Chart A when one of the products is selected in the Total Sales chart. In this case, the user selects Product 1 and Chart B will turn into Chart A where it will show only the data for Product 1; in this case I have it showing current year and previous year for Product 1.

How can I get Chart B to change into Chart A when clicking the Product from Total Sales?

Thanks.

EDIT: I understand how to use buttons and bookmarks to show different charts on the same report, but I do not know how to change the visuals based on the selection from another visual.

lp280388 · Answer

mcash&nbsp;&nbsp; &nbsp;would it be possible to give a sample graph of the output?

mcash · Answer

I included a screenshot in my OP. I want Chart B to be shown by default and Chart A hidden. Once user clicks any of the products listed in the left chart I want it to hide Chart B and show Chart A for the selected product; in this case the user clicks Product 1 and it shows CY vs PY for ONLY Product 1 and not an average of all selected products.

lp280388 · Answer

mcash,&nbsp;would this help?&nbsp; these are related pages.https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/#:~:text=Select%20the%20visual%20to%20be,the%20value%3A%20is%201%E2%80%9Dhttps://www.youtube.com/watch?v=a9AMSovkZcI&nbsp;&nbsp;

mcash · Answer

I think these are pointing in the right direction, but not quite there. The first link is close to what I need, the only issue is the solution relies on ISFILTERED and my information is already filtering by the Product, meaning it would automatically activate.

lp280388 · Answer

mcash&nbsp;In that case, you may have to create a copy of the Product column and use that in isfiltered()

Forum Discussion

Change chart based on another graph's selection

5 Replies

Related content

slicers automatically selected based on another slicer selection

Fabric graph

updating one tile based on selection in another tile

Switching graphs based on the selections on another graph

Creating Cumulative Graphs