Forum Discussion
Change chart based on another graph's selection
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.
Resolver IIAnonymous, would this help? 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%9D
https://www.youtube.com/watch?v=a9AMSovkZcI
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
Anonymous In that case, you may have to create a copy of the Product column and use that in isfiltered()