Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Link multiple value column

Hi ,

I've a issue here. I am trying to create a relationship between two tables as shown in the picture. I am looking to have one table that filters Minimum requirement, actual skills , Description, current positions based on the name that i have in slicer. For some reasons I am getting the duplicate values in my table and i couldn't able to figure it out where it is coming from.

Any help would be greatly appreciated.

Thanks,

Relationships

Need Help

v-kelly-msft
6 years ago
Hi Anonymous ,

Click the visual>go to field>right click the column(not showing all the data)>"show item with no data":

Check whether this way will present all the data.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

7 Replies

amitchandak
Super User
6 years ago
Anonymous , You can create a concatenated column and use that as key

key = [col1] &"-" & [col2] &"-"& [col3]
- Anonymous
  Not applicable
  6 years ago
  Hi Amit,
  
  Thanks for your reply, I tried merging two columns in both tables and used as a key. When i was trying to plot the tables the output looked liked this. The required value columns comes empty. I am still missing some connections i guess. Thanks,
- Anonymous
  Not applicable
  6 years ago
  Hi Amit,
  
  Thanks for your reply, I tried merging two columns in both tables and used as a key. When i was trying to plot the tables the output looked liked this. The required value columns comes empty. I am still missing some connections i guess. Thanks,
  - Anonymous
    Not applicable
    6 years ago
    Somebody help, Please.
    
    Thanks !!