Power BI Data Modeling help needed

[Rohit17]

Hi everyone,
Hope you are doing well. 

The requirement is to show all details of customer in one view.
Field paramter table is used to show the data in tables visual and slicer to slice the data.
we have created hierarchical slicer using field parameter table. 

User should be able to select one or more of column of one or more table. issue occuring is whenever user select the product table column and WP table column error is coming which is given below because of no relationship between two tables.. 

Please suggest how can we fix this. or model or any other way to show all details of one customer in one table view. 

[Anonymous · Accepted solution]

Hi @Rohit17 ,

I reproduced your problem, in my relational model, because since there is no direct relationship between WP and ET, the visual object does not know how to combine them. This results in an error being reported.

You need to reorganize the relationship between your table, according to the business logic to determine the direction of screening and its relationship, you can refer to the following documents.

Model relationships in Power BI Desktop - Power BI | Microsoft Learn

or below blog:

Can’t determine relationships between the fields: bidirectional — Fred's Data Adventure (fpk3.com)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly