Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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