i have taken two data sources
1. sample superstore data - excel
2. coffee chain -- Access
i have created dashboard 1 with USA State MAP (sample superstore)
in dashboard 2 contains 2 sheets states wise sales (sample superstore) and state wise profit (Coffee chain)
in dashboard 1 created action filter, when click on state is should go to dashboard 2 and display state sales and profit.
i have clicked on state Washington in dashboard 1, the dashboard output is as shown below
i have done data blend on state
please check attached workbook for reference.
Book10.twbx 1.7 MB
The filter on Dashboard 2 doesnt seem to sync to the state you clicked on Dashbaord 1?
Also you said you did blend the data on 'State' - what does this do behind the scene? Does this mean it creates a join between 2 datasources?
I have 4 different data sources which could have common global filter 'State' but not sure if I can merge all 4 data which could lead into dropping of some rows or data being inaccurate.
question - what does blending on 'State' do to data?
I dont this the filter is getting sync on dashboard 2 based on state you select on dashboard 1
Also later after changes the action filter to different state from dashboard 2 then both sheet 2 & 3 should change.
This is my requirement.
As you mentioned getting data from 4 data sources, i don't have an option to try and replicate your scenario.
so, please approach tableau support team, they will definitively find a solution for your requirement.
Even in your example with 2 data sources the filter is not getting synced. Check the twbx you attached. The sheets get filtered based on what you click but the filter doesnt sync and show the state you selected.
How do you reach to tableau support team?
Contact Tableau support team with the below email id (explain your scenerio)
The best way to reach support team, check the below link
Have you tried doing it at the sheet level? (Not going through dashboard actions)
Right clicking on the filter on the worksheet can be applied to other worksheets and that should give the desired result. Please tell me if this doesn't work.
I do apologize for the delay on this response.
Issue still remains as I want on click of a 'Store' on MAP the dashboard 2 should filter and sync for that store.
To get this on click action it has to be sync filter.
How can you achieve this with your approach?