Forum Discussion

Class66Loco's avatar
Class66Loco
Advocate I
2 years ago
Solved

Hyperlinking text across three columns using URLs listed vertically?

Hello,


I have three columns which contain Risk description text. I've split the original data into these three columns as the raw data is in one SP List column and the Power BI report requires this format. So columns are: Risk 1, Risk 2, Risk 3.

 

I get the urls from another data table and these are listed vertically in Power Query and in a separate Risk SP List. 


Is it possible to hyperlink the three columns so they link to the relevant URL in the vertical list?
Each risk text contains the risk UIN which is in the risk URL if that's of any help?

Thanks

 

  • Class66Loco , Based on what I got,

    You need to create columns(May be 3 columns) like

     

    Url1 = "<Common URL>?UIN=" & [Risk 1]

     

    Mark this column and Web url and use that in visual

1 Reply

  • Class66Loco , Based on what I got,

    You need to create columns(May be 3 columns) like

     

    Url1 = "<Common URL>?UIN=" & [Risk 1]

     

    Mark this column and Web url and use that in visual