A better way to dynamically update chart?

[KerryIBCLC]

Hi,

I'm looking for a better way of dynamically updating a chart that I have in a dashboard.  I need to display the meetings per year as in the screenshot below when selecting the year from the table view in the dashboard.

I currently have multiple dashboards, charts and slices setup one per year.  Whilst it gets the job done its very clunky.

Is there a better way of going about this please?

Thanks, Kerry.

[SkrOYC]

https://www.youtube.com/embed/nK-Aq_ak_T8

[KerryIBCLC]

Thank you.   So I'm currently trying to write the expression for the row filter condition of a slice which will then display the correct filtered rows for the chart.

I've now got a text column [Year enum] with suggested values of the years column so the user can choose from a drop down.  

I need to be able to compare the value of this drop down to the value of all rows that contain the same value for the [year] column.

I've tried 

IN([Year enum], SELECT(LLL Stats[Year],[Year enum]=TEXT([Year])))

but that's not working. 

Cheers again 🙂

[KerryIBCLC · Accepted solution]

Based my app on https://www.appsheet.com/templates/How-to-search-with-a-Slice--Dashboard?appGuidString=7e3e1bed-6576... and got there in the end.  Thanks @SkrOYC .