Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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. 

 

 

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Anonymous So you would split that out based on comma in Power Query. Then you can categorize each column as a Web URL

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Thanks For your time,
      But i need all the comma separated values in single row, Don't spilit to multiple columns, Do you any other ideas, Please let me know....