They are three different workbooks with data across years. Must link the workbooks together based on user selection of a year using parameters.
1. Create the Year Parameter
2. Drag the year dimension to filter box and open the condition tab
3. Use the formula ([Year] = [Parameter 1])
4. Follow the step 2,3 for the other workbooks
Initial tableau dashboard Parameter filter (Right-click and “Save link as…”)