Forum Discussion

Patv's avatar
Patv
Icon for Helper II rankHelper II
5 years ago
Solved

How to create hyperlink for comma separated values in Power BI

Hello All,
I need help creating hyperlink to comma sepated values in a column......
 
Let's say I am pulling three column from oracle db in power bi desktop. If you see the below screen, I get two comma separated "Related Project No" for each "Request No" and also getting comma separated URL for both Related Projects in "Related_Project_No_ULR" column from oracle table. 
 
If you see above when I click on  Related Project NO (e.g.341183), Power bi shows entire URL and hence I get error message when opening a URL because actual when I click on 341183, it should only open url (I want  separate hyperlinks  for when I click on related project 341183)  http://pmattdev.it.att.com/itg/web/knta/crt/RequestDetail.jsp?REQUEST_ID=341183
 
if you have notice here there is a constant URL text http://pmattdev.it.att.com/itg/web/knta/crt/RequestDetail.jsp?REQUEST_ID=
and then we need to add " Related Project No" value at the end for each comma separated values...
 
I don't have to show the "Related Project No URL" column in the report, it's for your information here that I have Comma Seperated  URL values form db as well if it helps to convery created Related Project No in hyperlink.
 
How to make each "related project No" that points to septate URL so when user click on it,  it suppose to opens up the web page?
 
I am struggling to make URL when there is comma separated values in a single cell. how to link each comma separated value to the individual URL form.
 
Please let me know if any question or if you think there is a direct way in Power bi to solve it rather than getting URL column from DB. Thanks for your help in advance!
 
Thank you,
Vipul
 
Need Help

2 Replies