1 Reply Latest reply on Oct 7, 2018 10:39 PM by ArseneXie

    Hiding Sheet filters in the dashboard

    Divya Sharma

      Hi Experts,

       

      Need your help urgently.

       

      I have created a dashboard using Superstore data source, which includes Three sheets + 1 title sheet (which is the part of Sheet 2) as below.

       

       

      Functionality is,When the user select the Sub-category from the 'Sub - category filter in sheet 1, then Sheet 2 is being visible (Sheet 2 is just to show text values). When any row from sheet 2 is  selected then Sheet 3 and its title will be visible (This part is working)

      Default dashboard includes only Sheet 1 with its filter 'Sub category = All' that means, sheet 2 and sheet 3 should be invisible.

       

      Issue is, if 'Sub category = All' , Sheet 2 and Sheet 3 is being invisible, but the filter in Sheet 3 - Manufacturer is not being invisible.

       

      Workbook attached.

       

      Please let me know how can i hide the Sheet's filters in the dashboard.

       

      Thanks.