Rough Overview of the Relationship between the tables that I am using
Chicken feet on both ends of the line means Many to many relationship, and I have used arrows to show the filtering. I have a matrix that used the column [Last PM Date] from [PM CHECKLIST] and another matrix that uses the [BRB date] from SP_USED. However, when I use the [Date] column from the Date table as a field in my slicer, and I select a range, for instance, January 2021 - Mar 2021, I will see dates from beyond my selected range in both my matrix, what could be the reason behind this?