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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.