Filter a graph by clicking on a row in a table

[arimoldi]

Hi,

I have 2 dataset connected with a many-to-many relationship and in a page I have 1 table based on one data set and 1 bar chart based on the second dataset.

As for now when I click on a row in the table the related bar in the chart is highlighted; is it possibile to filter the chart showing only the selected bar, not just highliting?

Thanks,

Andrea

[jolind1996 · Accepted solution]

Yes, it is possible to filter the chart to show only the selected bar, instead of just highlighting it. You can do this by using the "Edit interactions" feature in Power BI. Here's how:

1. Select the table visual, then go to the "Format" tab in the Visualizations pane.
2. Click on the "Edit interactions" button.
3. In the bar chart visual, click on the filter icon (it looks like a funnel) to change the interaction between the table and the chart from "Highlight" to "Filter".

Now, when you click on a row in the table, the chart will be filtered to show only the selected bar.

Best regards,

Johannes