Forum Discussion
Link to Hyperlink
Hi All,
I have requirement like, i need to change the link to Hyperlink.
Example: i have a link "https://google.com/" . What i have done is i have craeted a calculated column by adding the server name at the end of link using DAX, It now looks like "https://google.com/ServerName1" , so that it will redirect to respective server details. Now the requirement is the above calculated column link must be changed like Hyperlink (
| Click here to Go |
)
Can someone suggest how can it be possible.
Thanks
Hi Sudharshan1919 ,
Please create the calculated column.
Completed URL = 'Table'[URL] & "ServerName1"Or
Column = LEFT ( 'Table'[URL], LEN ( 'Table'[URL] ) - 1 ) & ".hk"Then set the data category of [Completed URL] and [Column] to "Web URL".
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hello Sudharshan1919 ,
This cannot be done in a calculated column but you can achieve the same using the table/matrix visual.
This link could be helpful to you.Please let me know if this isn't what you want.
Hi Sudharshan1919 ,
Please create the calculated column.
Completed URL = 'Table'[URL] & "ServerName1"Or
Column = LEFT ( 'Table'[URL], LEN ( 'Table'[URL] ) - 1 ) & ".hk"Then set the data category of [Completed URL] and [Column] to "Web URL".
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
