Cascading selection filters

[Anonymous]

When you make a selection in a chart, for example by clicking on one of the bars in a bar chart, it applies a filter or highlight. Then when you click on a second visualization, it resets the first selection. Is there a way to have it so that these cascade instead, like for example I click on the first chart and it filters based on that, then I click on the second one and it filters based on that, on top of the filter applied when I clicked on the first one?

[ausisfury]

Hey aabi01, did you ever get this to work ? 

Thanks! 

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

I try to create the sample table below.



I create two visualizations shown in the following screenshot.



When I click 2016 in first bar chart, it filter the second visual. You want to select one row based on first filter, right? If it is, please select "CTRL" and one row of the second visual, please review the following screenshots.

click 2016 year in first visualselect the first row based on first filter
Best Regards,
Angelia

[Raaassotto]

Cascading filters don't work in my Power BI report. I did the steps following @v-huizhn-msft advice. I press "ctrl" when I choose filter in another visual. And still the previous filter being canceled when I chose the following.