You can achieve this with following steps:
1. Create a parameter with exact values from the common field. you can use this parameter with both data sources.
2. Drag the common field into filters shelf wherever needed.
3. Edit filter and add the condition
Common field name = parameter created.
4. Now in the dashboard, show parameter control and use this to toggle the views.
If this helps, pl mark as helped!
1 of 1 people found this helpful
One limitation of using a parameter will be that new values in the dataset will not appear automatically in the parameter.
I might recommend creating a union in your data sets - any fields the 2 datasets have in common should be named the same and included in the union. Any non-common fields will be outside the union.
Tyler Garrett outlines the process rather eloquently here:
Thanks All for the responses ;
I have few common fields and does blending makes any difference from Union from performance or data retrieval point so that i can use that field as filter directly avoiding parameter ?
UNION Can be done with only similar table structure - the data sets I am referring do not have same number of columns.