Year is in the original table. So I created two extra tables ; StartYear and EndYear to help with filtering and Year range selections.
So anywhere within the dashboard am not using Year, but rather using EndYear field or StartYear field. for graphs plotting mainly (year range) On this specific one.. I just need to pick the most current year which am picking using the EndYear filter.