Table filter

I'd like to be able to select a record in a table and have a chart on the dashboard filtered by that record. For example in PerformancePoint you can create a KPI list and then have a filter action to filter a line chart by the selected KPI. Ideally it would be good to have something similar to Tableau chart actions where you can customize which charts are affected by the filter, method of activating the action (click, hover etc). I understand this might be complex so I'd settle for a special type of table which restricts you to one dimension and many measures, and clicking on a dimension value would filter all charts on the dashboard.