Hi Anusha, sounds like you need a parameter sheet swap.
Step 1 - create a parameter with your 4 options (Impressions, Source, Campaigns, Submissions)
Step 2 - create a calculated field that is just your parameter name
Step 3 - for each sheet that you want displayed, firstly expose the parameter and ensure the selection is for the sheet that you want to view (i.e. line up your Impressions sheet with Impressions selected on the parameter), then drag the calculated field onto your filter. Using our example, only Impressions should be selectable. Select this and click ok.
Step 4 - rinse, wash, repeat for all 4 parameters, when the parameter changes the viz will collapse because the data is being filtered out.
Step 5 - tidy up, remove any titles, remove any fixed height/width settings, and setup any containers etc to ensure your viz doesn't keep changing size when you filter stuff in and out.
Create worksheets and drag to vertical container in dashboard and add action filter with exclude all values option.
BI, Aspire Systems (India) Pvt Ltd
Hide&show.twbx 1.1 MB
Is there a way where we can hide the spaces when we are not displaying the sheets? Just when we click the text, the worksheet should be displayed below and if we hide it, the layout container should disappear.
Did you checked my workbook.
Please ping me my number.