Forum Discussion
Converting hyperlink to text value
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.
- Thank you, Yolo!