The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!
@Anonymous , change if interaction can help
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Change the default interaction from cross highlighting to cross filtering.
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
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