Forum Discussion
jatneerjat
Helper V
8 years agoHow power bi create relationships internally
Hi, I have two tables one table1 have customername,country and states and another table table2 have customer,countryname,statesname and salary. i have 2 slicers for the columns i have in my tabl...
ricardocamargos
Continued Contributor
8 years agoHi jatneerjat,
If I understood your question Power BI matches tables when the values are equals on both tables. If table 2 has the correspondent value on table 1, you will see the filter working.
It's important to take care about space on text columns, if your columns contains space before/after the values probably you are gonna see nothing returning to you, you have to handle it (Power Query has the "TRIM" function to remove spaces before/after).