Hello Community,
I have a Line Chart on Worksheet A whereby the columns are the Years of the dataset.
I currently have a filter for the Year field that is linked other worksheets on my Dashboard.
I would like to implement a feature whereby the user can click on the Year on the Linechart worksheet A, and this will then filter the other worksheets. Therefore I would be able to remove the need for the Year filter on the Dashboard.
Can you please provide me with direction on how to achieve this.
Kind Regards
@Niklas Heinecker
Hi, in this case you can:
a. Create a parameter, of integer type, that allows all values.
b. Create a calculated field, so you can use it as a filter:
YEAR([Date])=[Year Parameter]
c. Drag or apply the filter to the sheets you want it to be applied, selecting the true value:
d. Create a Parameter Action (Worksheet/Dashboard Menu, Actions, Change Parameter)
e. Configure the Action:
Attached you will find an example workbook.
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
