Forum Discussion
Helper ICan't display relationship in visual
Hi dear Community,
I'm trying to show a table in visuals but it's not allowing me to show columns from different tables. Let me show you. I have the following data model:
I'd like to show the red-squared columns in a table. They are all related through the CdU table. When I create the table I want, I see the following message:
If I remove the 'tactics'[name] column, it works:
Also, If I remove the columns for Vendor and Product, it works with the Tactic:
So I guess the problem is with the relationship between tables cdutechs/cduproducts and tactics.
Any ideas?
Regards,
Gabriel Crespo
Hi gcrespo ,
According to your description, it seems that you got some error message when create the visual which applied the fields from different tables. As checked your data model, the six fields from 4 tables. And there is no direct relationship among them. So that is the root cause of problem...
You can refer the following links to fix it:
Use DAX:
powerbi - Can't determine relationships between the fields - Stack Overflow
Can’t determine relationships between the fields: bidirectional — Fred's Data Adventure
Create relationship base on your scenario:
Can't display the data because Power BI can't determine the relationship between two or more fields.
Best Regards
3 Replies
- amitchandak
Super User
gcrespo ,
cdu and cdumitre need to be bi-directional if your model permits
You can make CDU to cduproductstechs as single direction
- gcrespo
Hi amitchandak ,
Thank you for your answer, however, I have tried your solution and it makes no difference.
Regards,
Gabriel Crespo
Hi gcrespo ,
According to your description, it seems that you got some error message when create the visual which applied the fields from different tables. As checked your data model, the six fields from 4 tables. And there is no direct relationship among them. So that is the root cause of problem...
You can refer the following links to fix it:
Use DAX:
powerbi - Can't determine relationships between the fields - Stack Overflow
Can’t determine relationships between the fields: bidirectional — Fred's Data Adventure
Create relationship base on your scenario:
Can't display the data because Power BI can't determine the relationship between two or more fields.
Best Regards
