Concatenate but dont show link

[JamesMurg]

Hi all

I want to link certain numbers to a hyperlink but show the number and not the hyperlink. is this possible using the concatenate DAX code?

Sorry I have had to redact due to security reasons.

But basically I have put the internal site followed by the column with the number but it shows the full site address along with the number on the end.  I just want it to show the number not the full link.

Hope this makes sense 

James

[JamesMurg]

Many thanks @sunilsofteg2006 & @amitchandak 

[amitchandak]

@JamesMurg , You can create a new column or measure and use that as per need.

new column = "https//abc.com?item_id=" & [Item Id]

[sunilsofteg2006 · Accepted solution]

@JamesMurg  You can use number column and then use conditional formatting. In conditional formatting, use Web URL and then select the full URL. By using this, you will be able to show only number as link. See below screen shot. Hope this helps you.