Forum Discussion
Lookup tables
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?
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
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-Forum/ba-p/963216
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/1447523#M607150
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"?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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
