Sorry, Just to be clearer:
I cant see a way to use the Measure Name as a filter for an Action between worksheets.
Are you using the same data connection for both charts?
Place both worksheets on the same dashboard. Click on the worksheet that displays the first sheet (multiple measures). In the options (small downwards pointing triangle in top right corner) click on 'Use as filter'. If you now click on one of the measures the second worksheet should update to display the values for the selected measure.
Thanks for the quick reply!
I think the problem I am having is that I am using the special "Measure Names" as my row dimenion values. Even after I selected "use as filter" I can see the action uses the filter with the "all fields" radio button selected and this dosent seem to work.
If I try to manually edit the action and choose the fields, there is no option to choose the "Measure Names" field in my targer or source fields. I think because this is a specailly derived field.
I have tried using parameters, but It is not possible to put the parameter value on the row to show all the values.
I was hoping that someone has had a similar issue and found a way around it.
Thanks for your help
You can you Dynamic Measure selection in your case. Helpful Links:
If you still have issue, Please attache worksheet with dummy data and will help in VIz
Can I know how to do this action filters for measure values with out the parameters because I may what all seen and when i apply actions the data for the other sheet should be seen.