Forum Discussion
Flitering on multiple visuals based on selections on different visuals
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,
The pie chart must represent the values of the selected stacked bar(s). Not sure I could do it with a slicer.
Thanks!
Microsoft Employee
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,
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?
