Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
Best Regards,
Angelia
Hey aabi01, did you ever get this to work ?
Thanks!
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.
Best Regards,
Angelia
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |