Forum Discussion
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
- amitchandakSuper User
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