Enabling User Access to Desired URLs in a Table Visual with Comma-Separated Web URLs

[jatin08941]

Hello everyone,

I have a requirement where a source column contains multiple comma-separated web URLs. I want to use this column in a table visual and provide the user with a clickable hyperlink button. When the user clicks on the button, a pop-up should display all the related URLs, and the user should be able to select the desired URL.

I have tried using tooltips, but tooltips cannot interact with the data. Additionally, I cannot create a calculated column because the source column contains a maximum of 7 or 8 comma-separated URLs.

Could anyone please suggest a better idea for allowing the user to access the desired URL from the table visual?

Thank you.

[v-yangliu-msft · Accepted solution]

Hi  @jatin08941 ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Measure =
SWITCH(
    TRUE(),
    MAX('Table'[Column1]) ="ABC",https://learn.microsoft.com/en-us/power-bi/fundamentals/service-basic-concepts,
    MAX('Table'[Column1])="DEF",https://www.bing.com/,
    MAX('Table'[Column1])="GHI",https://learn.microsoft.com/en-us/power-bi/fundamentals/fabric-get-started#create-a-lakehouse-to-store-data)

2. Cell elements —Web url .

Once you turn it on, you’ll be able to pick a field to use as the URL for the column.

3. Result:

Once you’ve picked the field and confirm the change, you’ll see the field values formatted as links in the table or matrix. If you hover over the link, you’ll see a tooltip showing the URL and clicking on it will open up the URL in a new tab.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly