I have created a report in which i have used a parameter to show and hide the sheets in dashboard.
now in all these three sheets i have used diffrent filter.Now,in dashboard ,through parameter,the sheets are hiding but the filter used remains in the dashboard.
Attached the workbook.when i select monthly in report display,the date filter(month) should only show ,others year and quarter date filter should hide and similar goes for quarter and year "report display" selection
Please help.Kind of stuck in it from long.
Thanks in advance,
Take a look here, and watch/follow the referenced video: We made a video of Sheet Swapping and Legend/Filter Popping on a dashboard.
It's not a simple trick, so it takes a bit of study/dedication. But you can do amazing things once you learn the trick!