On a report I have two tables, they come from two different master datasets and have no relation (their is no allocation between them). They both have a common field that contains the same set of values. i.e Table1.column  a = Table 2.column c. Can I have one slicer that will show these values and cut both tables. .. ? I would have said a perspective but given there is no relationship/allocation between them how would this work? I know I can use two separate slicers but that's not intuitive to users given the data contained and Id like to avoid that path. Suggestions welcome . . . 

Hi

We have also the same needs on our side, and i never succeed implement a slicer applying on the table from different data sets.

The only solution i see is to create an artificial allocation relation, either between the 2 object or a third object.

Regards

William,

In my experience I haven't seen this work.

Maybe create Tabs, have a report and it's slicer on each Tab.

Best,

Audrey

I have successfully accomplished this in an ad-hoc report that contained master data sets, but I had to create a MASTER master data set, if you will.  I combined two master data sets into another master and created lookups to pull in the fields that were missing in either data set so the filter would work.  The fields on the report must be present in both data sets for the filter to work correctly and the values must be the same in both data sets or it will return "various" in your report. 

As an example, if the Asset Status field will be used on the report, but it's not present in both data sets, you must create a lookup to the other data set to populate the field.  My lookup uses asset serial number to match the data in both data sets.  It takes a little work to get it set up correctly, but it's worth it in the long run. 

Hopefully that helps point you in the right direction.