Forum Discussion
Creating Links for the values in a Column
Hi there,
Needing help with this request.
I have a table visual that includes a [Employee Name] column. I need to make all the names as hyperlinks and when I click on the link, it will take me to a second page in my power BI report which contains a table with all the information filtered by the selected s employee's name.
Any help will be really appreciated!
thanks!
In this way is not possible. Instead you need to create a drillthrough.
In this page is explained: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
The example is about a bar but is the same for tables.
Hi, Anonymous
It's impossible to use this way. But you can use the drillthrough feature to achieve what you want, just like the one Nori provided above. Here's my addition and demonstration of how to use drillthrough:
Based on your information, I create two tablesNext, add a report page in the lower left corner of the view page.
Create a Table Visual in the second page and put Employ in the Drill Through under the Visualizations page
Create a visual on the first page of the report as well, then right-click on the name and the Drill Through button will appear
Once you select the page you want to drill through, you'll get information about that user
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
- Greg_Deckler
Community Champion
Anonymous I don't believe you can do exactly that but you can get close. Create a column that holds the URL and set the Data category to Web URL. Then put your person name and the URL column in a table. In the Format pane, expand the URL icon format card and turn on Values. See attached PBIX below signature for example.
hI Greg_Deckler thanks for the idea, but the drill through solution was more suitable to my problem...thanks.
In this way is not possible. Instead you need to create a drillthrough.
In this page is explained: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
The example is about a bar but is the same for tables.
Hi, Anonymous
It's impossible to use this way. But you can use the drillthrough feature to achieve what you want, just like the one Nori provided above. Here's my addition and demonstration of how to use drillthrough:
Based on your information, I create two tablesNext, add a report page in the lower left corner of the view page.
Create a Table Visual in the second page and put Employ in the Drill Through under the Visualizations page
Create a visual on the first page of the report as well, then right-click on the name and the Drill Through button will appear
Once you select the page you want to drill through, you'll get information about that user
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
