Forum Discussion

moni87d's avatar
moni87d
New Member
7 years ago
Solved

Multiple slicers for multiple queries

Hi, I am trying to create a report for 4 queries with data. All queries have these same columns:

- Project Name

- Project Number

- Audit Date

And I want to be able to filter the data with these slicers.

I initially created bridge queries for Project Name, Project Number and Audit Date, but the problem was each slicer wasn't being filterted by the others. For example, if Project A was only audited one day, if I filter by Project Name = Project A and then I go and filter by date, I would get a list of all dates from all other projects as well! 

 

I thought I could solve the issue with "Many to Many" relationships, but I can only create one active relationship between queries, which means that only the filter of the active relationship will work on all data.

Hope it makes sense ... can anyone help me figure this out please? 

Thanks