Forum Discussion
Add web URL to a Column
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
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
5 Replies
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?
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
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
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
