Forum Discussion
One table puts multiple filters on another table
Hi Anonymous , Gotcha!
Basically, you would need to apply 3 filters to the second table based on the click on the first table. (3 filters as there are 3 columns in the first table)
I may not have explained that right, but I do know exactly what you mean.
However, rather than clicking on a 'Line', when you are clicking on 'Bob Smith', you are filtering the page by 'Bob Smith', not the line. 'Bob Smith' is a value within your table.
Unfortunately though, I'm not aware of a way to do what you are looking for. I have a similar matrixes that I'm working with and I had to use the Drillthrough function to get this to work. Which works better than I had imaged by the way :smileyvery-happy:
If anyone does give you a better idea though, please do let me know. . :smileyhappy:
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