Hello,
I have two lists with a relationship. One field is a multi select lookup field "Solution" which contains values from the Second list and displays Title.
First list
ID Title Area Solution
1 X A Test1, Test2, Test3
2 Y B Test4, Test 1
3 Z C Test5, Test6, Test3
Second List
ID Title Name
1 Test1 Don
2 Test2 Sam
3 Test3 Rob
4 Test4 Linda
5 Test5 DG
6 Test6 John
When I try to display the values of the column "Solution" after creating the relationship, it displays the "ID" field not "Title" in power BI. The table report will look like this:
Title Area Solution
X A 1, 2, 3
Y B 4, 1
Z C 5, 6, 3
I want to display the Title in the second list but it displays only the ID. Any solution?
Thank you.