Have you tried adjusting the "Apply to Worksheets" option in the filter? That may get you to where you're going. If not, do you have a workbook we could take a look at? If the data is sensitive, check out this article and scroll down to the bottom to see about anonymizing data: Prepare Workbooks for Sharing | Tableau Software
It's not a filter though, it's an option in the "Pages shelf". No such property exists for Pages.
I'll look into making a sheet with dummy data tomorrow.
Can it be true that I cannot upload TWBX files to the community?
I have attached a workbook with dummy data. In the Dashboard I have an example of what I want to do. The "Pages" (year development) only controls one of the sheets, but I want it to control both, like it was a global filter. How can I make it do that?
TWBX file from my OneDrive: https://onedrive.live.com/redir?resid=E8E24D94C40A98B4!298588&authkey=!AFprn3UUONFbHwE&ithint=file%2ctwbx
Thank you for the .TWBX - you should have been able to upload it but regardless, I was still able to access it from the OneDrive. After taking a look, I believe I have solved the issue.
I actually think this may be a product defect - would you mind telling me how you got to this point and what version of the software you are using? I'm not sure how the workbook arrived at it's current situation, but I've resolved the issue using the following steps:
- Navigate to Dashboard 2 and from the Year controller, click the down arrow and de-select "Synchronized"
- From the same dashboard, go to Sheet 6 and click the down arrow and select "Show Page Controls"
- From the newly-exposed Year page controls, click the down arrow and de-select "Synchronized"
- From the original Year page controls, click the down arrow and re-select "Synchronized" and the duplicate filter will disappear
- The remaining Year filter will now affect both panes.
I've uploaded the adjusted .TWBX here - let me know if you have any further issues.
This is confirmed to be a defect with the product that will be addressed in a future release - thanks for identifying the issue for us! I hope the fix from my prior comment will help you work around the issue.
This appears to still be a defect in 10.4. Do you know what release is scheduled to fix this?
I realise this has probably already been considered, but there are more efficient methods of using the year measure as a page switch in the first place.
If you are intending on replicating this functionality in a working format, try using a filter action as a Single Value (slider)
Then select the Apply to Worksheets > (select an option) to get the filter to work across each sheet.
I can get Filters to work across many sheets within one dashboard doing just what you described. But I wanted to use the animation feature of Pages to synchronize across many sheets in one dashboard. The sheet with the Page control does have an option called "Synchronized" but it does not have the kind of "Synchronize" that Filters has to "Apply to Worksheets" and "All Using this Data Source".
It looks like the animation feature of Pages is not yet available on multi sheet dashboards when using 10.4?