Filter Other Data Source

[Cardi0z]

I have two data source. I want to slicer on Data Source 1, can filter whole data on Data source 2.

[Vallirajap]

Hii @Cardi0z 

Try this,

Go to model view,

Make a relationship between the Data Source 1 and Data Source 2 usnig date column or other columns

Did I answer your question?

Mark my post as a solution, this will help others....!

Hit the Kudo also,

Thank you

[Idrissshatila]

HEllo @Cardi0z ,

I would suggest you work your data model as a star schema data model and you'll get what you want.

https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

[Cardi0z]

this is my scenario

[Anonymous · Accepted solution]

Hi @Cardi0z ,

You might also consider creating several MEASURES (depending on the number of sliced fields in Source1) and adding them to the filters in Source 2 Visuals.
example:
create a new measure

date fitler = 
VAR _date = ALLSELECTED('Table1'[Date])
VAR _filter = IF(SELECTEDVALUE('Table2'[Date]) IN _date,1)
RETURN
_filter

and apply it to the visual's filter.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group