hyperlink from data in text box

[Niki]

Good morning, 

I have created a report and working with bookmarks to go from a page with 'overall' info to a page with more details.

So the report is about different projects and when clicking through, towards 'the end' the user is on a page with all kinds of detailed info about 1 project. Most of the projects have a external website as well, this I would like to show in a textbox with the possibility to click through to the website. I know I can just make a text like ' Click here to visit website' and put the hyperlink of the website behind the 'here' for example. But then I need to type of paste the hyperlink in there, but it should be pulled from the data and depending on the selected project. In my data I have a table with column A = Projectnr and column B = hyperlink (already formatted as web URL) Is it possible to do what I want?

- Next question would be, what to do when multiple projects are selected? (Or is it possible in powerBI to obligate 1 selection? Because now I can always use ctrl and select multiple items)

Not every project has a webpage, so is there also  a possibility to hide the box shen there is no data in column B?

for me it is not neccessairy the box is a textbox, it may also be a button or an image.

Hope some one can help me out.

Thanks!

[v-yuezhe-msft]

@Niki,

Firstly, based on my test, it is possible to display hyperlink with text in textbox/button/image and dynamically display the value based on slicer selection. To work around this issue, you can create a table visual instead. And you can turn the URL icon ON and change the column displayed name to “Click here to web”.

Secondly, it is not possible to force “Single Select” in slicer, as you said, we can use Ctrl to select multiple items.

Thirdly, based on my research, it is not possible to hide the visual as you describe. We can add a new column to work around.

Column = IF(Table1[hyperlink]=BLANK(), "no content", Table1[hyperlink])

For more information, please check the pbix as attached.

Regards,
Lydia