Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |