Flitering on multiple visuals based on selections on different visuals

[yg]

Hi, i'm new to power bi and was wondering if it is possible to filter two different pie charts based on the selection of two different bar charts?  When I select a bar on the second bar chart it automaticaly remove the filter on the first pie chart and apply the new filter on the second pie chart.  

Thanks,

[BenEaton]

I've not found a way to do that, but you could add a slicer in place/addition to one of the bar charts?  That way you could filter one and the other together.

[yg]

The pie chart must represent the values of the selected stacked bar(s).  Not sure I could do it with a slicer.

Thanks! 

[v-sihou-msft · Accepted solution]

@yg

In this scenario, I think the issue should be the relationship design in your model. If the field you put in the pie charts can be sliced by the selection field in those two bar charts. The filter should not be cleared. For example, you have one bar chart for "Internet Sales by Year", another bar chart for "Internet Sales by Product", and a pile chart with "Reseller" measure populated. If your Reseller Fact table contains both Date, Product key column, and build the relationships to DimDate and DimProduct properly, your Reseller measure should be sliced properly when you select in both charts.

Regards,

[longhp]

In my scenario, while click on the chart the rest chart are reflect the data accordingly, let replace the reseller chart in your example by Sales Representative Volume Contribution which have SR1, SR2, SR3, SR4, I need the see the data by year in Calendar chart  of SR2 and Category is Bike. It seem we can not select both SR2 and Bike in 2 seperates charts as the filter combination. Can we do that?

[Greg_Deckler]

If not already out there, this would make a fine Idea, "sticky" visual filters. https://support.powerbi.com/forums/265200-power-bi