I have a list of measures by month as a data view for the top sheet. The bottom sheet has the same information but as a line graph. I want to link these 2 sheets such that when i click on a measure lets say "budget profit" it should give the line graph for only that below. Can we make a filter action do that? Or is there a work around. I dont want to do a parameter because i want the user to get the line graph right from the top sheet by clicking.
I don't believe this is possible, although I could be wrong. As you mentioned, you could create a parameter that allows the user to view each measure individually, so they see the Crosstab and Line Charts for that measure only.