I have a dashboard with sheet swapping using parameter and filter. Workbook contains 3 sheets. A pie chart showing top states in each product category based on expenditure, pie chart uses category as filter and one parameter to select top 5. A bar chart showing expenditure for product category in each state, and uses state as a filter. A treemap showing category wise expenditure, uses category as filter.
Sheet swapping works successfully on dashboard. But the problem is all filters, parameters and legends are shown when a single sheet is selected. Is there a way to show only the relevant filters, parameters corresponding to the sheet selected. I want to only display category filter and top parameter when pie chart is selected.
Your help is very much appreciated.
Does anyone know the answer ? Please help