Lookup tables

[GoofyPete]

I have a table (DataTable) with many columns having 0/1 values, indicating no/yes.  I created a table (YesNoTablew) with two rows, mapping 0 to no and 1 to yes..  When creating charts on these columns, I want the legend to have no/yes rather than 0/1.  But when I try and set a relationship of more than one of the columns in DataTable to YesNoTable, I get a "There are ambiguous paths between DataTable and YesNoTable..." error. 

Having multiple columns mapping to the same "lookup" value seems such a common thing.  How would I accomplish this in Power BI?

[Anonymous · Accepted solution]

Hi @GoofyPete ,

As far as I know, this issue should be caused by the wrong activity relationship.

Generally speaking, there should be only one active relationship between two tables. If there is more than one relationship, it needs to be set as an inactive relationship.

So I think there may be another active relationship between DataTable and YesNoTable.

For example:

Relationship1: DataTable - YesNoTable

Relationship2:DataTable - TableA -  TableB - YesNoTable

You can refer to the specific official documents to view the relationship model between the constructed dimension table and the fact table.

For reference: Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs

Best Regards,
Rico Zhou

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

[mickey64]

For your reference.

Please check the data type of the "0/1" column.
Is the data type of the "0/1" column set to "Text"?

[Idrissshatila]

Hello @GoofyPete ,

Please share sample data in a usable format (not screenshots) that fully addresses your issue or question.

Avoid including sensitive info or unrelated content. Need help uploading data? Visit https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Show what you expect based on the provided data.

For faster answers, see https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...