1 Reply Latest reply on Nov 21, 2018 12:26 AM by Jozf Mathew

    Displaying relevant filters, parameters on sheet swapping

    Jozf Mathew


      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.