Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
arimoldi
Resolver I
Resolver I

Filter a graph by clicking on a row in a table

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

1 ACCEPTED SOLUTION
jolind1996
Resolver II
Resolver II

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

View solution in original post

1 REPLY 1
jolind1996
Resolver II
Resolver II

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!