question

FirasSufan-1116 avatar image
0 Votes"
FirasSufan-1116 asked LeonLaude commented

Multi select look up field text values are not displayed in Power BI Report

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.

not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LeonLaude avatar image
0 Votes"
LeonLaude answered LeonLaude commented

Hi @FirasSufan-1116,

Please note that Power BI is currently not supported in the Q&A forums, the supported products are listed over here https://docs.microsoft.com/en-us/answers/products.

You may ask the experts in the dedicated Power BI forum over here:
https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums


(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)


Best regards,
Leon

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Leon,

I do not have an org account and so I can't post the question there!

0 Votes 0 ·