3 Replies Latest reply on Jan 12, 2019 6:25 PM by Shinichiro Murakami

    How to show/hide sheets or auto resize containers dynamically based on parameter value

    Swetha J

      Hi All,

       

      I want to show or hide  sheets or a single container (Which has 2 sheets right side of the dashboard) based on parameter value selection.

       

      When parameter value 'Qtr' is selected all the sheets in the dashboard show display.

      when parameter value 'Month' and 'Week' values are selected, dashboard should show only 'Datewise date'  sheet.

       

      Example 1: when parameter (Qtr/Month/Week)  value  'Qtr' is selected the expected output should be  as below fig

       

       

      Example 2 : when parameter (Qtr/Month/Week)  value 'Month' is selected the expected output should be  as below fig

       

       

      Example 3: when parameter (Qtr/Month/Week)  value 'Week' is selected the expected output should be  as below fig

       

       

      Finally I'm expecting dashboard should show by auto resizing of the container and eliminating the blank sheets when a parameter values 'Month' and 'Week' selected.

       

      Attached sample workbook.

       

      Thanks in advance

      Swetha J