How to filter table visual by clicking on items in stacked column chart visual.

[char23]

Hello, 

I have a stacked column chart that uses a slicer with 4 different measures to compare data across two months. I want to be able to click on a legend element (or data for one of the measures), and have a table visual that shows all rows where those measure conditions are true. Right now, when I click on a section in the column chart, it only filters my table for the two items I have on the X-axis and it does not apply the measure. Also, when I select a bar the entire bar column is selected instead of just selecting the portion that I click on. I have tried using visual filters with measures that return 1, but since each measure is different, this does not calculate my table visual correctly. If possible, what would be the best method to execute this?

[Jason_1981]

Might try doing regular bar chart instead of stacking. With just 2 months of data shouldn't be too terribly busy and allow you to click on a single bar in the chart to filter down the table. Also could be some ambiguous relationships depending on how it is set up. I have had some odd results with many-to-many relationships between tables when trying to filter from chart click to table. A many-to-one relationship can also produce odd results, for example if I have 1 repair order ID and many Task Lines on each order. If I have a chart for how many orders, click on a day with 10 orders in the chart, I may show 50 task lines in the table.