Many-One Relationship when there are Unique values in both tables

Hi Anonymous ,

There are two ways to edit a relationship in Power BI.

The first method to edit a relationship is using the Editing relationships in the Properties pane in Model view, where you can select any line between two tables to see the relationship options in the Properties pane. Be sure to expand the Properties pane to see the relationship options.

The other method of editing a relationship is using the Relationship editor dialog, which you can open many ways from within Power BI Desktop.

Please refer to the following document for more information.

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Neeko Tang

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