Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
You may take a look at the post below.
https://community.powerbi.com/t5/Desktop/composite-primary-key/td-p/307604
You may take a look at the post below.
https://community.powerbi.com/t5/Desktop/composite-primary-key/td-p/307604
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |