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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Cross filter bar chart from table visual by selected value only

I am wanting to filter a bar chart with trending data based on a selected Metric ID from a table visual. There is a most recent date slicer always selected and I know how to edit the interaction for the date slicer to not affect the trend chart.

 

The table visual with the Metric ID I want to use to filter the trend chart is filtered by the date slicer and there are other fields in the table such as compliance status (could be pass or fail). If a metric is passing this month and I click on the Metric ID in the table, it filters the trend chart, but only shows the trend for months it was passing. How can I make the trend chart also show the months the metric was failing when clicking the Metric ID from the table?

 

Basically just want the table fields to act as independent filters when clicked and not filter based on all values in the table. Like it would if chosen from a slicer. Thanks!

4 REPLIES 4
amitchandak
Super User
Super User

@Anonymous , change if interaction can help

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

 

Interactions.png

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
lbendlin
Super User
Super User

Change the default interaction from cross highlighting to cross filtering.

Anonymous
Not applicable

Thank you for the response, but it is already changed to filter instead of highlight. What is happening is that when I select Metric ID from the table, the chart below filters based on the other values in the table also. I want to be able to click on Metric ID in the table and it act as an independent filter such as a slicer. When I choose Metric ID from a slicer the chart below shows all the values I'm looking for.

Hi , @Anonymous 

What you want is to individually disable the interaction between this visual object and other visual ,right?

If help ,please check  the part of document regarding no impact icon.

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

 

3.png

You can refer these related videos.

https://www.youtube.com/watch?v=6WcbHzXb_QA

https://www.youtube.com/watch?v=9UvYI3Ppzrs

 

Best Regards,
Community Support Team _ Eason

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors