Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I currently have the following formula in Excel. When I upload to power query within Power BI, it takes the formula as plain text. Is there any way to show "click here" in the 'Project Name' column instead? Currently, I "copy and paste values" the Project Name field within Excel before uploading to Power BI to circumvent the issue.
Any help would be greatly appreciated!
Best,
Solved! Go to Solution.
Hi @AW11
In power query of Power BI Desktop, it cannot support the hyperlink , it will return only text format, but you can implement in a table visual, you can refer to the following solution.
1.Split the hyperlink and the text to two columns.
2.In Power BI Desktop, set the link data category to "Web URL"
3.In a table visual, put the text column to the visual, then set the conditional formatting to 'Web URL', and select the link column.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Wondering if anyone has any ideas?
Hi @AW11
In power query of Power BI Desktop, it cannot support the hyperlink , it will return only text format, but you can implement in a table visual, you can refer to the following solution.
1.Split the hyperlink and the text to two columns.
2.In Power BI Desktop, set the link data category to "Web URL"
3.In a table visual, put the text column to the visual, then set the conditional formatting to 'Web URL', and select the link column.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the July 2025 Power BI update to learn about new features.