Forum Discussion
Flitering on multiple visuals based on selections on different visuals
- 9 years ago
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!
If not already out there, this would make a fine Idea, "sticky" visual filters. https://support.powerbi.com/forums/265200-power-bi