How keep chosen value in one chart while choosing value in another chart

[Marina]

Hi,

I have several charts of different categories in my report: Name, Price, Amount and other. And resulting chart with measure Revenue.

When I use slicer I can select one value in Name, another value in Price and third value in Amount. And Revenue measure is filtered with these categories. 

But when I use Treemap for categories instead of slicer while selecting one value in Name another value selection in Price is cancelled and all values are selected in other categoties. I.e. only one category filter may be applied in one moment. 

How can I keep one chosen value in Name while choosing another value in Price and third value in Amount? Like it is may be done in slicer.

Thank you!

[juliancolombo]

Is there a possible answer for these question?

[ankitpatira]

@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.

[Marina]

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?

[wonga]

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.

[Marina]

I get it. It makes sense.

Anyway thank you very much! )