Forum Discussion
Relationship & Filters
I have 4 tables, each table having site, department and date column in common. I created a many to many relationship between these tables using site column. I just need to show these 4 tables without any transformations in the report. I created 3 slicers site, department and date. Site and department are filtering every table, but the date filter is filtering only the table from which the date column is selected. What needs to be changed to filter every table when a date is selected. TIA
1 Reply
Hi , i think you need to create a new table with unique values and try to make the relationships from the unique table to the other tables ( delete the old relationships ) and you need to have a date table and also link it with the new unique table you created it . hope this works with you .
