Flitering on multiple visuals based on selections on different visuals

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,

Need Help

v-sihou-msft
9 years ago
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,