Creating Links for the values in a Column

[Anonymous]

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! 

[Nori · Accepted solution]

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.

[Anonymous · Accepted solution]

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 tables

Next, 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.

[Nori · Accepted solution]

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.

[Anonymous]

Thanks Nori, that solved my issue. 

[Greg_Deckler]

@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.

[Anonymous]

hI @Greg_Deckler thanks for the idea, but the drill through solution was more suitable to my problem...thanks.