Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
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.
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.