Forum Discussion
One table puts multiple filters on another table
See here's the odd part about it. I have a date slicer on right now, but it won't filter the date for both of the tables. If I have the date field from one table in it, it will only work for that table. If I use the date field from the other table it only works for the other table. Like I said in the first post, these were originally the same exact table when they were brought in. I just used the group by function to modify one of the tables. It has to be an issue with the relationships, but I can't figure it out. A many to many relationship is exactly what kind of relationship there is. I have cross-filter direction set to both, and I don't see why that would affect anything anyways. Right now, I have the two tables linked by Salesman. Interestingly, if I use Salesman as my slicer, it works for both of the tables. I don't understand why the same doesn't work for date or product category. Any tips on where to go from here would be greatly appreciated. I haven't used PowerBI in about 2 and a half years up until the beginning of this week.
Bump