Forum Discussion
Combing graphs from 2 datasets on the same tab
Community SupportHi Anonymous ,
USERELATIONSHIP should help you in your scenario by creating inactive relationship between tables. Please refer to this case.
https://community.powerbi.com/t5/Desktop/USERELATIONSHIP-issue/td-p/478744
If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
But I am not trying to do a calculation I am trying to have filters work for 3 different data sets. I do not see how this resolves my issue.
- vivran22
Community Champion
Is it possible for you to share the sample data file or snapshot of the relationship view?
Regards,
Vivek
Not sure if this will help. So I have 3 data sets on one page. I have two them working, the third one it will not let me create another many to many relationship. So my Jobs and Utilization tables are working and joined to the calendar table and the company and yard table. This enable both to filter correctly. My budget and revenue table it will not let me join to the company, yard or calendar table. As you can see I have added another calendar table but it is only letting me make one join there. Does this help?
PaulDBrownAnonymous
The general consensus is to avoid many-to-many relationships where possible (it can wreak havoc in calculations...)
Can you not create lookup/dim tables as bridge tables between the different fact tables by linking common fields (and removing duplicate values to enable one-to many relationships)?
If you can provide sample fact tables with dummy data/values I will happily give it a try
