Answered by:
Format column in powerpivot table as HyperLink column

-
Can I display a powerpivot column that contains valid URLs as click-able hyperlink column in excel ?
I tried to re-write my query to return the results in for of excel hyperlink function but this didn't work, any tips ?
FAQ
----
Regards,
Ahmed Ibrahim
SQL Server Setup Team
My Blog
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.
Question
Answers
-
Hi Ahmed -
Not aware of a way to pull that off in a regular Excel pivot table. Probably possible with some VBA.
Here are some other options:
1. Use PowerView (Excel2013 required)
- with the URL column selected, set the Advanced property in your PowerPivot model for Data Category to Web URL (Power Pivot actually recognized the string format and suggested this for me)
- then create a PowerView report containing a table with the URL column and the values will be surfaced as clickable hyperlinks.
2. Another option would be to move your model to Analysis Services and create URL Actions that would allow the user to click through the dimension members to the associated URL
Let me know if that helps.
Brent Greenwood, MS, MCITP, CBIP
// Please mark correct answers and helpful posts //
http://brentgreenwood.blogspot.com
- Edited by Brent GreenwoodEditor Saturday, October 05, 2013 4:17 PM
- Marked as answer by Ahmed Ibrahim - MSFTMicrosoft employee Sunday, October 06, 2013 5:25 AM
All replies
-
Hi Ahmed -
Not aware of a way to pull that off in a regular Excel pivot table. Probably possible with some VBA.
Here are some other options:
1. Use PowerView (Excel2013 required)
- with the URL column selected, set the Advanced property in your PowerPivot model for Data Category to Web URL (Power Pivot actually recognized the string format and suggested this for me)
- then create a PowerView report containing a table with the URL column and the values will be surfaced as clickable hyperlinks.
2. Another option would be to move your model to Analysis Services and create URL Actions that would allow the user to click through the dimension members to the associated URL
Let me know if that helps.
Brent Greenwood, MS, MCITP, CBIP
// Please mark correct answers and helpful posts //
http://brentgreenwood.blogspot.com
- Edited by Brent GreenwoodEditor Saturday, October 05, 2013 4:17 PM
- Marked as answer by Ahmed Ibrahim - MSFTMicrosoft employee Sunday, October 06, 2013 5:25 AM
-
Thanks Brent, I ended up using VBA since I wont to have URL and URL friendly name
like the column say SkyDrive and the behind URL forward to www.SkyDrive.com
I used the technique in this link
http://www.get-digital-help.com/2011/09/29/follow-hyperlinks-in-a-pivot-table/
FAQ
----
Regards,
Ahmed Ibrahim
SQL Server Setup Team
My Blog
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.
- Proposed as answer by JMichaelBrown Thursday, February 19, 2015 3:25 PM
- Unproposed as answer by JMichaelBrown Thursday, February 19, 2015 3:26 PM