The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I have 4 datasets in power bi Skills,Panel, Daily slot utilisation, summary of daily slot utilisation, and I'm trying to create a relationship between skills to Daily slot utilisation and summary of daily slot and panel to Daily slot utilisation and summary of daily slot in cross filter direction as both but for the skills to daily slot utilisation is becoming inactive why? When I'm try to activate this error coming
You can't create a direct active relationship between daily slot utilisation and skills because that would introduce ambiguity between tables skills and Panel. To make this relationship active, deactivate or delete one of the relationships between skills and panel first
Hi,
Here is a simplified example what causes these kinds of errors:
Consider this picture. Here if I try to activate the relationship between calendar and invoices the same error arises. This is because if the relationship would be active there would be two paths from where the calendar filters transactions. Either directly or via Invoices. In your case the bi-directional relationship would cause similar behavior.
Proud to be a Super User!
User | Count |
---|---|
14 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
28 | |
19 | |
13 | |
8 | |
5 |