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.
Hello,
I'm working on a model on a power bi desktop, and I'm modeling these tables below :
So as you can see in this model the relationship between the table Relevé de temps et consultants is not active and they are connected with the field identifiant.
Also, the relationship between the table Projets et calendar is not active and they are connected with the field Date.
So how can I change this relationship to be an active relationship? Any tips? I tried to change it directly as is shown below but it didn't work :
@Anonymous , Consultant is One; in one join and many on another join.
Can you provide some more information on project , consultant and Relevé de temps, what kind of data
@amitchandak the data that we are working on projects contains the code of projects that we are working on and they are related to a time record (relevès de temps) indirectly with code project by the intermediate of the table Table.
@Anonymous , You need to avoid many to many join. Create some common dimesions and do that. Is it possible ?
https://www.seerinteractive.com/blog/join-many-many-power-bi/
https://radacad.com/many-to-one-or-many-to-many-the-cardinality-of-power-bi-relationship-demystified
@amitchandak you mean like this :
And how can I do it also for the relation between Projets and Calendar?
@Anonymous
Is the relationship between Consultants and Projets a date field?
It looks to me that the Consultants table filters the Date column in the Projets table (either directly or indirectly) which creates a conflict with the calendar table.
I suggest you create the relationship between the calendar table and the consultants table (instead of Calendar -> projets)
Proud to be a Super User!
Paul on Linkedin.
@Anonymous , I need to understand about three tables I mentioned above. can you share some samples so I can understand their relationship and suggested what is needed.
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |