Beginner Help with Date Filtering

[Dmnut32]

The PowerBi model is built of of two lists. First list is task sumbitted by employees and stores all the data about the tasks. Second list is the hour data that is related to the task. I am trying to get all data filtered by one date slicer. I want to filter TaskCompleted from list one which is the date the task was completed and DateCreated from list two which is the date the resource hours the employee spent was inputted. Usually one task has multiple hour inputs before completion. The current relationship is built off of the the first list automatically generated ID from sharepoint and written to the second list when hours are inputted. I tried searching youtube but having a hard time finding help. I am a novice with PowerBi and really have only dealt with one data source models. Any help is appreciated. Picture of My current model to hopefully help explain what I am trying to do.

[v-mengmli-msft]

Hi @Dmnut32 ,

The Power BI Slicer is mainly used for filtering the data, when you put a column of a table into the Slicer's field, the other visualizations that contain the table data are updated according to the Slicer options. Slicers in Power BI - Power BI | Microsoft Learn

Based on your description, did you create a LookUp column in List 2 regarding the ID column of List 1? If your requirement is to realize filter function of List1 to List2 in the report by LookUp column, you can create one(ID of List1) to many(LookUp column) relationship. Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

If the above is not what you are looking for, please provide more details for your needs such as examples or screenshots in your next reply. A public link to the pbix file (which does not contain sensitive data) is preferred. If my reply solves the problem, please accept it as a solution.

Thank you for your support and understanding of Power BI.

Best regards,

Mengmeng Li