Forum Discussion
Helper IVRelationship not working anymore after adding column from example
The solution was to capitalize all the values in one column.
In the other table I had to remove the { and } and then it worked again.
Strange that it changed values without any instructions.
Super UserHi lekkerbek
It seems like that, you are facing problem with the relationship between your tables in Power BI after adding a new column. I suggest few steps to resolve the issue. pls follow below steps.
- Verify the relationship both the tables after adding new columns. such as still the relationship is actieve.
- Check the data types columns involved in relationship.
- check the cardinality and cross filter direction.
Still problem not resolved, pls share more details or screenshots of your model and the steps you’re taking. This can provide more context and help in diagnosing the problem more accurately
If you need additional info Pls go through this Relationship troubleshooting guidance - Power BI | Microsoft Learn
lekkerbekBeforeAfter
The only difference I can see is that before the data in AccountID was capitalized and after it isn't anymore eventhough I didn't add a step to change it. Could this be the problem and how can I revert it (as it is not a step)?
- lekkerbek
The solution was to capitalize all the values in one column.
In the other table I had to remove the { and } and then it worked again.
Strange that it changed values without any instructions.