Can you add a Slicer between two PowerBI Datasets

[dalabera]

Hi,

Using the DirectQuery for Power BI datasets and Analysis Services (preview) feature to build a dashboard coming from 2 different PowerBI Datasets (Operational and Accounting). 

Have a page that have multiple tables showing measures from different tables from those 2 different datasets. 

Need to filter the page the Reporting Year and Entity.  Right now have 4 slicers to handle this. Being doing some research and haven't found is there a way to create a table or complete slicer that will allow me to filter the data and only use two slicers so it filters the tables on both PowerBI Datasets.  Is that possible?

Thank you. Appreciate any input or thoughts?

[DataInsights]

@dalabera,

In a pbix based on two published datasets, you can create a master dimension table for filtering. Create a one-to-many relationship between the master dimension table and the corresponding dimension table in each published dataset. Example:

ReportingYearMaster --> ReportingYear (dataset 1)

ReportingYearMaster --> ReportingYear (dataset 2)

Filters/slicers should use ReportingYearMaster.