1 of 1 people found this helpful
Your workbook doesn't have the filter action in it, so I can't be sure of the problem, but my guess is that you have the "Target Filters" section set to "All Fields"
This will try to filter based on all the fields on "Locations" sheet, which will narrow it down to just a single location on the trail. Instead, you'll want to filter only on "Trail"
Note that it says "Missing fields on locations". This indicates that the "Trail" field is not in the view on the locations sheet, so go back to that sheet and drag "Trail" over to detail:
Then the filter action should work as expected.
Thank you! That was quick.
Sorry - posted workbook without filter.
It's here, and after adding in the "Trail" filter, it still isn't working the way I'd like.
When the user hovers over a trail, I want the Trail Elevation graph to filter to just the one trail being hovered over. With the updates, it still shows all three trails.
Is there a way to do this?
Updated workbook and xls attached.
Sorry - missed that it was needed on locations as well as elevation sheet.
Thanks very much - that did it!
Great. Glad to hear it worked!