Create a http link + additional information from the data

[TcT85]

Hi,

So I have created  and published a visualization on open tasks.

In the PCO column i have a ID for the task.

To see additional information, I will need to open the browser and type http://qualisys/#/pct/pco/218

But I would like to link this adress http://qualisys/#/pct/pco/ + the PCO ID.

For example if i click on the PCO column "218" it will automatically open this link http://qualisys/#/pct/pco/218 in a browser.

Is this possible?

[TcT85]

Hi johnt75,

Awesome, it works.

Thanks for the help

[johnt75 · Accepted solution]

You can add a calculated column to the table like

Item URL = "http://qualisys/#/pct/pco/" & 'Table'[PCO]

[TcT85]

Hi johnt75,

Thanks for fast response, but this is not what i was looking for.

Here is a example from microsoft word, where i linked the text.

I just want to be able to open this link by just clicking on the PCO ID.

[johnt75]

Set the category of the new column to be Web URL and you can then use conditional formatting on a field in a table visual to add the URL

[TcT85]

OK nice.

Since im very short in space, is it possible to just show the last 3 letters/numbers of this "Item URL" ?

[johnt75]

you don't need that column at all, you can set conditional formatting on another column e.g. PCO