I have two columns with ID and Year.
Ex:
ID1--- 2015,2016,2017,2018
I wanted to create a parameter and that parameter should be taking the year value that I select from the year dropdown.
I will use that parameter as a date filter in different charts
Attached is the data csv file
Thanks for the help
1 answer
I don't think you need a parameter. If the other charts are using the same data source, you can apply the filter to all worksheets using "This Data Source".
If the other charts use a different data source, you can relate the data sources by year, then apply the filter to all related data sources.
If you put the two sheets on a dashboard they filter together:
