Thanks, but I think you've misunderstood what I'm trying to do. Doesn't that filter ALL the records in the entire graph? I only want the filter to affect one of the bars in the graph, so I can COMPARE ONE vs. ALL.
e.g. I've just tried what you suggest (I think). I've added two measures to my graph. I've added the dashbaord filter:
But this just means that BOTH of the bars are filtered by the selection. I want one to be filtered, and the other to stay the same, so I can compare one practice with all practices. Am I doing something wrong here? I've tried playing around with sets, but dashbaord action filters seem to completely override sets also. I must be missing something!
Pleas see attached updated workbook.
PrescriptionsDashboard.twbx 1,012.5 KB
I don't think its possible because action fires on entire dimensions and measures of the dashboard.
Action doesn't work for any particular measure of a sheet which you're expecting.
For more details about action you can follow the link: