How to create hyperlink for comma separated values in Power BI

[Patv]

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

and when I click on 341272 it should only open http://pmattdev.it.att.com/itg/web/knta/crt/RequestDetail.jsp?REQUEST_ID=341272

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

[amitchandak · Accepted solution]

@Patv , I think you have to split this into two columns. One column will have one hyperlink only.

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

[Patv]

Hi Amit,

Ok. I knew I can split the column but was wondering If there is a way to add multiple hyperlinks in a single column.  Now, I know there is no way at least for now. Thank you for your reply. Appreicate it.