Add web URL to a Column

[Anonymous]

Hi all,

I have one column which is Intersection ID and another column which is the Google map link to the intersections. I want to add these links to the Intersection ID, where by clicking on Intersection IDs a browser opens up and show that intersection on Google map. 

Here is my problem. When I turn Web URL on in the Conditional Formatting for the column of Intersection ID, the prompt window that pops up just gives me this option to use either the first or last link for all the intersections, while I have all the links for all the intersections and I want the corresponding URL in each row is assigned to the Intersection ID in that row.

I am following this tutorials from YouTube (https://www.youtube.com/watch?v=Wz2aD0XvkUk). The only difference that I see is that the column of links in that video has a special icon next to it (please see the fig below), while mine does not have.

 

Does anybody know what is that icon? Does it show the format of the column? If so, how can I adjust the format?

Thank you for the help 🙂

Masoud

[v-lili6-msft · Accepted solution]

hi  @Anonymous 

The special icon next to it means it is a measure not a column

https://insightsoftware.com/blog/calculated-columns-vs-measures/

For example:

and create a meausre as below:

Measure = MAX('Table'[link])

Result:

and here is my sample pbix file, please try it.

Regards,

Lin

[MFelix]

Hi @Anonymous,

that is the symbol of a measure, If you look at the 30 seconds you see that he refers to a measure and categorized as an URL.

Can you share a mockup of tyour data?

[Anonymous]

@MFelix Thanks for the answer. Actually I found my solution. I created a relationship between the database which includes the links and the database with Intersection IDs and it worked out.

Thanks again

Masoud

[Anonymous]

@v-lili6-msft  Thanks for the comprehensive explanation.

Actually I found my solution. I created a relationship between the database which includes the links and the database with Intersection IDs and it worked out.

Thanks again

Masoud

[v-lili6-msft]

hi  @Anonymous 

It's pleasant that your problem has been solved, 😁  please accept the reply as solution, that way, other community members will easily find the solution when they get same issue. 

Regards,

Lin