Forum Discussion
Enabling User Access to Desired URLs in a Table Visual with Comma-Separated Web URLs
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.
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
1 Reply
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