u/taeyong18

Hello everyone! I’m a new Power BI intern and I’m encountering a problem.

I have 2 tables, one big (fact) table which contains invoices data which we paid to our vendors, and there is a “country code” column inside it which I’m trying to connect to “legal entity code” column from the other (dimension) table.

The relationship works, but the data from the dimension table returns as blank. I already changed the type of both data to “text”, and tried clearing/formatting the code (i forgot the function name cuz i’m at home now) but nothing seemed to work. I also tried changing the relationship to be both ways, many to many, etc, all things but no combination seemed to work.

What could the solution be, and what am I doing wrong?