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