User filter by column

I Have a table that is a golf score card. Each column is a different hole. I am looking to do a pie chart that shows the percentages of strokes you have taken on that hole. This works great for one hole. The issue is that I don't want 18 of these pie charts in my dashboard, I would like it so that there is one pie chart that you can choose what hole to get your stats on. Is there a way that I could set a user filter to switch between holes/column's?