Forum Discussion
Super UserPass dynamic URL from table row to external site
Hi,
I’m working on a requirement where I need to create a table visual in Power BI. The customer would like each row to be a clickable link that redirects to a website, with the corresponding item pre-filtered.
Any suggestion to achieve this.
Hi AnkitaaMishra,
Yes, Create a calculated column in your data model that generates a dynamic URL with the filter parameter.
e.g.
ItemURL =
"https://yourwebsite.com/search?item=" & [ItemID]-
In your table visual, add this
ItemURLcolumn. -
In Model view → Column properties, mark this column as Data Category → Web URL.
-
In the table visual, you can then set the column formatting to display as a clickable link.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!-
2 Replies
- grazitti_sapna
Hi AnkitaaMishra,
Yes, Create a calculated column in your data model that generates a dynamic URL with the filter parameter.
e.g.
ItemURL =
"https://yourwebsite.com/search?item=" & [ItemID]-
In your table visual, add this
ItemURLcolumn. -
In Model view → Column properties, mark this column as Data Category → Web URL.
-
In the table visual, you can then set the column formatting to display as a clickable link.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together! -
- Shahid12523
Community Champion
- Create a calculated column with a dynamic URL using DAX:
DynamicURL = "https://site.com/report?filter=Table/Field eq '" & [Item] & "'"Set the column’s Data Category to Web URL.
- Add it to your table visual and enable URL icon in formatting.
- Optionally, use a label like “View Details” with conditional formatting.
