Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Getting two attachments in same row for one ID

I have ID column, attachment column and URL Column For one ID I will be have multiple attachments and there will be URL for that ID also. I have two show all Attachments in single line for that...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous 

     

    Thank you very much saud968  for your prompt reply.

     

    For your question, here is the method I provided:

     

    Here's some dummy data

     

    "Responses"

     

     

    Create a new table.

     

    AttachmentsWithLinks = 
SUMMARIZE(
    'Responses',
    'Responses'[ID],
    "Attachment_Links", CONCATENATEX(
        'Responses',
        "<a href='" & 'Responses'[URL] & "' target='_blank'>" & 'Responses'[Attachment Name] & "</a>",
        ", "
    )
)


    Go to the Visualizations pane and click "Get more visuals".

     

     

    Search for and install Shielded HTML Viewer.

     

     

    Adding an HTML Viewer to a Report.

     

     

    This way, each attachment name is a clickable link that opens the corresponding URL in the browser.

     

    Regards,

    Nono Chen

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

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous 

 

Thank you very much saud968  for your prompt reply.

 

For your question, here is the method I provided:

 

Here's some dummy data

 

"Responses"

 

 

Create a new table.

 

AttachmentsWithLinks = 
SUMMARIZE(
    'Responses',
    'Responses'[ID],
    "Attachment_Links", CONCATENATEX(
        'Responses',
        "<a href='" & 'Responses'[URL] & "' target='_blank'>" & 'Responses'[Attachment Name] & "</a>",
        ", "
    )
)


Go to the Visualizations pane and click "Get more visuals".

 

 

Search for and install Shielded HTML Viewer.

 

 

Adding an HTML Viewer to a Report.

 

 

This way, each attachment name is a clickable link that opens the corresponding URL in the browser.

 

Regards,

Nono Chen

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    hi 

    Note 1 : suppose if you have 15 columns. how 

    Note 2 : how we can we format the table in powerbi can we format like that. can you please create a sample powerbi

    Note : it was asking license can you prefer another visual or can we do in phyton Visual

     

    Thanks and Regards