concatenate too long when add another dimensions in a table

[Cobra77]

Hi  ,

We would like to add a url based on ticket numbers.

To avoid adding a bulky column, we put it as an indicator , like :

Numéro de Ticket avec liens = IF (ISINSCOPE('25 - Tickets'[Numéro du ticket]), CONCATENATE(CONCATENATE("HTTPS:// .... .easyvista.com/autoconnect_mail.php?field1=5C0F05156F1D&field2=&field4=%7B0A283E%7D&field5=ViewDialog&field6=", MIN('25 - Tickets'[Numéro du ticket])),"&field7=RFC_NUMBER") , BLANK() )

when we add data of other dimensions in the table, it is really very long.
an idea without adding it in column?

Thanks for your help , advice.

[johnt75]

Make sure the column has a Category of Web URL then you can add it as a column in your table visual and turn on URL Icon in the visual settings