Forum Discussion
How keep chosen value in one chart while choosing value in another chart
Marina You can control interactions by selecting slicer -> Format tab under Visual Tools -> Edit Interactions. You can choose to filter, highlight or none actions for other visuals based on selection in slicer.
No, that is not exactly what I'm asking about.
Imagine you have slicer on Product (from Product1 to Product 10), Amount(from 1 to 15) and Price (from $20 to 100$). You can choose in Product slicer Product1, in Amount slicer you choose 6 and in Price you choose $40.
But when you use for Product, Amount and Price not sclicer but for example Treemap the following happens:
you choose Product1 in Product treemap, then you choose 6 in Amount treemap. But when you choosing amount in Amount treemap the selection of product in Product treemap is cancelled and all products are chosen again.
So in the same time you can make a choise only in one Treemap, not in three of them simultaneously like you can do in slicers.
So my question is it possible to make a choice in Treemaps like in scilers - to keep chosen Product in Product treemap and choose Amount in Amount treemap and Price in Price treemap?
This probably won't help in terms of offering a solution, but I think the slicers are designed to be the primary filtering mechanism in Power BI and the visualizations like treemap, donut, pie, etc. are there to bring your data to life and provide meaning.
General rule of thumb in my experience with Power BI is that if you want to filter on any particular page of a report without using the side panel filters, then slicers should be your go to visualization for that purpose.
I get it. It makes sense.
Anyway thank you very much! )
