How to SET hyperlink as values instead of URL in table chart column using power bi

[saivina2920]

I have two column like EmpNo and HyperLink.

Hyperlink will have some URL. 

But, I don't want to show the full URL to end user. When user see the table they should know only the EMPNO with Link in the HyperLink.

When they click on the link (EMPNO Link), it should go to respective link. 

How do we do this..?

For example and reference as below.

[amitchandak]

@saivina2920 , In values you have option for URL icon or in conditional formatting you have one option for Web URL, is that not helping

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables

[saivina2920]

Thanks for your help..

WebURL is there. But, How to replace the values as "ENPNO" values instead of the whole URL.

pls. refer the image screenshot for reference.

[saivina2920]

any help..this is very urgent.

[amitchandak]

@saivina2920 , Please check this part of the document I shared

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables#format-link-t...

[saivina2920]

I tried...But, still not coming....

can i have sample file...?

[v-janeyg-msft · Accepted solution]

Hi, @saivina2920 

I created a simple file. You can check it. Hope it helps.

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

[saivina2920]

Yes. I got it. Thanks