URL on table to go to website

[Emerald70]

ID	Name
100	test1
200	test2
300	test2

I have a website URL as https://working:  +ID
when we click on 100 it would redirects me to https://working:  100  
it should work on any ID and take the respective value and values we show top3 on table and dynamically changes
Suggest the best possible approach to do this ??

[vicky_ · Accepted solution]

create a measure:

URL = "https://working:  " & SELECTEDVALUE(Table[ID])

Go to Format > Cell elements > URL, and select the measure above. \

for the top3 part, you can use a visual filter - go to the filter panel > ID > Top N and fill in the top N settings there

[Ritaf1983 · Accepted solution]

Hi @Emerald70 
Create from PQ / Calculated column with the needed URL concatenated to ID :

Modify the data category as URL :

and filter the wanted table but Top 3 values according to the wanted measure:

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[anmolmalviya05 · Accepted solution]

Hi @Emerald70,

To achieve this in Power BI, you can dynamically create a clickable link in a table visual that redirects to a URL based on each row's ID. Here’s a step-by-step guide:

Step 1: Create a Calculated Column for the URL

Go to the Power BI Desktop, navigate to your table, and create a calculated column that generates the URL based on the ID column.

Use a DAX formula to construct the URL dynamically:

URL_Link = "https://working:" & [ID]

This will concatenate the base URL with the ID for each row.

Step 2: Set Up the URL as a Clickable Field

After creating the URL_Link column, go to the Data View in Power BI.

Select the URL_Link column, then under Column tools in the ribbon, change the Data category to Web URL. This setting will make the URLs clickable in the table visual.

Step 3: Filter the Table Visual to Show Only the Top 3 Rows

Add the necessary fields (like ID, Name, and URL_Link) to a Table visual on your report.

Use a Top N filter to show only the top 3 IDs:

Go to the Filters pane for the table visual, and add a filter on the ID column.

Select Top N as the filter type, set it to show the Top 3, and apply a field (e.g., ID or any other field you want to sort by).

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Let's Connect on LinkedIn: https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in

[Ritaf1983 · Accepted solution]

Hi @Emerald70 
Create from PQ / Calculated column with the needed URL concatenated to ID :

Modify the data category as URL :

and filter the wanted table but Top 3 values according to the wanted measure:

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[vicky_ · Accepted solution]

create a measure:

URL = "https://working:  " & SELECTEDVALUE(Table[ID])

Go to Format > Cell elements > URL, and select the measure above. \

for the top3 part, you can use a visual filter - go to the filter panel > ID > Top N and fill in the top N settings there