Forum Discussion

rishabh770's avatar
rishabh770
Frequent Visitor
3 years ago
Solved

Missing Data after creating a relationship

Hello All,

 

I have created a relationship between the two tables using the serial number. The serial number column in both the tables have text data type and contains both text and numerical values (few serial numbers are like SHA5678 and few like 129876). After creating the relationship the serial numbers with only numerical values have disappeared from the visualisations. 

 

I have also compared the values in both the tables (they are exactly same).

 

Can someone help me in resolving this issue?

 

Thanks 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    rishabh770 , This means One side of the table is missing the serial numbers or Many size have null.

     

    This can be because of spaces.  You can use trim and clean in power bi in join columns

     

    Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4