in Power BI, want to display multiple URLs in a single column of a table visual

[durgaraop21]

In Power BI, How to create hyperlink with comma separated in same column in table visual its has to clickable to open respected hyperlinks

Sample URLs

https://images.google.com/

https://lens.google/

Need to dispaly only single column, Dont spilit into multiple URL.

If you see the below screen, I get comma separated "URLs" for each  and also getting comma separated URL 

 

[Anonymous]

Hi @durgaraop21 ,

Maybe you can try below M code:

let
    Source = Table.FromRecords({
        [ID = 1, URLs = "https://images.google.com/, https://lens.google/"],
        [ID = 2, URLs = "https://example.com/, https://test.com/"]
    }),

    SplitURLs = Table.SplitColumn(Source, "URLs", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"URLs.1", "URLs.2"}),
    AddHyperlink1 = Table.AddColumn(SplitURLs, "URLs.1_Hyperlink", each if [URLs.1] <> null then "Link 1: " & [URLs.1] else null),
    AddHyperlink2 = Table.AddColumn(AddHyperlink1, "URLs.2_Hyperlink", each if [URLs.2] <> null then "Link 2: " & [URLs.2] else null),
    CombineHyperlinks = Table.AddColumn(AddHyperlink2, "CombinedURLs", each Text.Combine({[URLs.1_Hyperlink], [URLs.2_Hyperlink]}, ", ")),
    RemoveColumns = Table.SelectColumns(CombineHyperlinks, {"ID", "CombinedURLs"})
in
    RemoveColumns

Best Regards,
Adamk Kong

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

[durgaraop21]

@Anonymous Thanks for your responce.

Iam expecting this result:

Need to show in single cell and clickable hyperlinks links

[nilendraFabric]

try this 

FormattedURLs = SUBSTITUTE(YourTable[YourURLColumn], ",", UNICHAR(10))

[durgaraop21]

@nilendraFabric Thanks for your responce.

Requirement:
Need this links become click-able hyperlinks in a report table to make it easier for my users when they view open the link?

[Fowmy]

@durgaraop21 

You can split the combined URL text into multiple rows in a single column using Split Column and choosing comma as the delimiter. In Power BI, set the Data category as Web URL

[durgaraop21]

@Fowmy  Thanks for the suggestion.

But i need show the data without spilit column, Each cell have different clickable Links.

Requirement:
Need this links become click-able hyperlinks in a report table to make it easier for my users when they view open the link?

[Fowmy]

@durgaraop21 
Let me understand your question first if you are trying to include two URL's inside a single cell in a table I don't think it's possible the only way you allow each url to be clicked is to have it on separate cells that means you need to split them into rows or columns.