Image based on slicer selection - broken link

[heatherforman]

Hello,

I am trying to get an image to appear when the person selected by the slicer is approaching their 25th reunion.

I created a new column using the formula below, and categorized it as Image URL. The viz is a table. The image is saved in a google drive and the access is set to "anyone with the link"

It is working, in that the broken image icon shows up when a person in the 25th window is selected, and nothing shows up when someone outside the window is selected. I just can't figure out why the link is broken. Any ideas?

Thank you!

Formula:

25th Image test =

IF('SDO Query'[Reunion Window Ind] = "25th Window", "https://drive.google.com/file/d/1C5D9M8RStdDVK0nYLu_RSgYBjnMbEl-T/view?usp=sharing","")

[OwenAuger · Accepted solution]

Hi @heatherforman 

After some Googling, it appears to work if you change the URL to this format, with the image ID following the final forward-slash:

https://lh3.googleusercontent.com/d/1C5D9M8RStdDVK0nYLu_RSgYBjnMbEl-T

The calculated column expression for this URL would then be:

25th Image test =
IF (
    'SDO Query'[Reunion Window Ind] = "25th Window",
    "https://lh3.googleusercontent.com/d/1C5D9M8RStdDVK0nYLu_RSgYBjnMbEl-T",
    ""
)

Does this work for you?

[heatherforman]

Yes! It worked, thank you so much!

It's actually showing up very tiny, but I'm sure I can adjust the formatting. It's always something 😂