Forum Discussion
Flitering based on selections in multiple charts
Hello friends,
I have two bar charts (SalesByProducts and SalesByMonths) and a table showing my sales.
I would like to click on a specific product bar in the SalesByProducts bar-chart and then on a specific month bar in the SalesByMonths chart so that my table will be filtered by BOTH Product AND Month.
Unfortunately, after selecting a product, when I click on a month bar - it CANCELES the selection of a product.
So it is either some Product OR some Month, not both.
I've played with different interaction types - doesn't help.
And I don't want to use slicers in addition to charts - not good to show the data twice.
How do you solve this?
Thanks a lot!
Michael
7 Replies
ThiyagsHelper II
Can you attach the dataset. or give a sample data
- Thiyags
It seems, the Power Bi does not have that option till now.
please vote it and add your comments in the following idea
- v-qiuyu-msft
Community Support
Hi Anonymous,
Based on my test, we can click on the bar in bar chart to highlight corresponding value in column chart, then click on the highlighted column to filter checked bar in bar chart. Please download the attached sample to test in your environment.
1. Click on bar "a" in bar chart.
2. Click on column "July" in column chart.
Best Regards,
Qiuyun Yu- v-qiuyu-msft
Hi Anonymous,
Thought set interaction as filter instead of highlight, it also works fine. See attached .pbix file.
I guess there might be some settings in your report cause the issue. Would you please share .pbix for our analysis?
Best Regards,
Qiuyun Yu