Can't display relationship in visual

[gcrespo]

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

[Anonymous · Accepted solution]

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.

powerbi - Can not display the data becuase Power BI can not determine the relationship between two o...

Best Regards

[gcrespo]

Hi @amitchandak ,

Thank you for your answer, however, I have tried your solution and it makes no difference.

Regards,

Gabriel Crespo

[amitchandak]

@gcrespo ,

cdu and cdumitre need to be bi-directional if your model permits

You can make CDU to cduproductstechs as single direction