Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

Reply
Marina
Frequent Visitor

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

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!

5 REPLIES 5
juliancolombo
Regular Visitor

Is there a possible answer for these question?

ankitpatira
Community Champion
Community Champion

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

 

 

2016-05-02_11-42-05.png

 

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
Continued Contributor
Continued Contributor

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
Frequent Visitor

I get it. It makes sense.

Anyway thank you very much! )

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.