I have a date filter which I need to use in 2 ways on one dashboard
I only need to pick the month and need one of the sheets to display trend based on 12 months prior that month
is there a way to split that filter somehow so I can have both on separate sheets but connected based on month selection on one.
You can use a date type parameter for month date selection, and then create a calculation like
[your date field] >= dateadd('month',-12, [the date selection parameter])
And drag the calculation to filter and select true.
If you provide a sample workbook, it will be easier to show step by step