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 All,
I have three tables each from a seperate process and all of them have a relationship with the WIP table (related column: serial number). I need the WIP table for additional information. Each process table has his own date. When I add a date filter from one of these tables in my report then it will not working, because I show information from all these tables in one overview. I need a separate date table, but the problem that I have is that I can only make one relation between two tables. How can make the relationships between these tables for a good working date?
Most of your relationships are bi-directional. That is creating a problem.
Also, why most of your joins are Many to Many.
If possible please share a sample pbix file after removing sensitive information.Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Hi @amitchandak ,
I am a beginner and I don't have enough experience in relationships. Power BI makes the joins automatically many to many. What do you advise me to do? After trying this I can share a example .pbix.
Thanks in advance.
Please create the correct relationship. You can right-click and delete the relations which are not needed. Power BI by default creates the relation on matching name.
So first correct the data model. Please refer
https://docs.microsoft.com/en-us/power-bi/guidance/
To help you further with data model I need pbix file. If possible please share a sample pbix file after removing sensitive information.Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
You can only close it by marking a solution. You can share how you fixed it and mark that as a solution.
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |